I have to teach a sql course for relational databases. The students (35 aprox.) will use their own laptop (Windows, MAC, Linux, etc). So I have to find the way for all of them to get the tool to take the course.
However, recently, I thought about to use Oracle cloud Autonomous Database (
free tier) instead of install the software in all the systems. (WEB SQL DEVELOPER can solve my problem I guess..)
The students have to load data for 4 different databases: movies, flights, projects and cars. So I am thinking in work with 4 different schemas.
I recently read from : "
https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-always-free.html#GUID-03F9F3E8-8A98-4792-AB9C-F0BACF02DC3E": - Maximum of 20 simultaneous database sessions
- Maximum of 2 Always Free Autonomous Database instances per Oracle Cloud Infrastructure tenancy.
So, considering the numbers: 35 students and 4 schemas. Rather than questions, I would like you to confirm some points.
- As there are 20 available simultaneous sessions and 2 available Autonomus Databases instances, in order to get all of them connect at the same time, the students can be splitted in 2 groups, e.g. 20 in one instance and 15 in the other one. ¿is my understanding correct?
- As I understand, there are no limitation about the number of users. So we can create 80 (20 users x 4 schemas) users in one instance and 60 (15 users x 4 schemas) users in the other one. is it correct?
- I already created one autonomous database. I want to test the 20 simultaneous sessions. Connecting to the WEB SQL DEVELOPER to the same user by using 20 Chrome sheets has the same effect?
- As a Free Tier account, I have €250/30 days free. Why I being charged €1.20 by day if my autonomous database is stopped?
- When we have no more credits or 30 days passed. Can I will continue have the same capabilities for all above for my Free tier account?
I really appreciate your help.
Regards
- As there are 20 available simultaneous sessions and 2 available Autonomus Databases instances, in order to get all of them connect at the same time, the students can be splitted in 2 groups, e.g. 20 in one instance and 15 in the other one. ¿is my understanding correct?
You should not need to split them. If you are using SQL Developer Web, we use connection pooling. So you would only have a small number of sessions connected across all the students. This means if they ALL try do something at exactly the same time, some of them would see a pause, but that is unlikely to be an issue unless they all do something very long running.
- As I understand, there are no limitation about the number of users. So we can create 80 (20 users x 4 schemas) users in one instance and 60 (15 users x 4 schemas) users in the other one. is it correct?
Correct.
- I already created one autonomous database. I want to test the 20 simultaneous sessions. Connecting to the WEB SQL DEVELOPER to the same user by using 20 Chrome sheets has the same effect?
No - see above about connection pooling. If you did something like SQL*Plus via a direct connection, you would see the error once you hit 20 sessions.
- As a Free Tier account, I have €250/30 days free. Why I being charged €1.20 by day if my autonomous database is stopped?
You should not be charged anything ever for free tier. Something is wrong there - contact the support folks via the chat
- When we have no more credits or 30 days passed. Can I will continue have the same capabilities for all above for my Free tier account?
Free tier is free forever.