Autonomous Data Warehouse provides three database services that you can choose when connecting to your database. These are named as HIGH, MEDIUM, and LOW services and provide different levels of performance and concurrency.
The HIGH database service provides the maximum amount of CPU resources for a query, however this also means the number of concurrent queries you can run in this service will not be as much as the other services. The number of concurrent SQL statements that can be run in this service is 3, this number is independent of the number of CPUs in your database.
The MEDIUM database service provides multiple compute and IO resources for a query. This service provides more concurrency compared to the HIGH database service. The number of concurrent SQL statements that can be run in this service depends on the number of CPUs in your database and scales linearly with the number of CPUs.
The LOW database service provides the least amount of resources for a query, and any number of concurrent queries you can run in this service.
As a user you need to pick the database service based on your performance and concurrency requirements.
The typical screen looks like as below,
If you need any further details, kindly leave your comments below.. Happy blogging.. :)
The HIGH database service provides the maximum amount of CPU resources for a query, however this also means the number of concurrent queries you can run in this service will not be as much as the other services. The number of concurrent SQL statements that can be run in this service is 3, this number is independent of the number of CPUs in your database.
The MEDIUM database service provides multiple compute and IO resources for a query. This service provides more concurrency compared to the HIGH database service. The number of concurrent SQL statements that can be run in this service depends on the number of CPUs in your database and scales linearly with the number of CPUs.
The LOW database service provides the least amount of resources for a query, and any number of concurrent queries you can run in this service.
As a user you need to pick the database service based on your performance and concurrency requirements.
The typical screen looks like as below,
If you need any further details, kindly leave your comments below.. Happy blogging.. :)
No comments:
Post a Comment