High Concurrent Queries in Oracle Autonomous Database
Question
When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.D.
When running high concurrent queries in Autonomous Database, the predefined service connection that should be used is DBNAME_HIGH.
The Autonomous Database provides different service connections that allow users to connect to the database with different resource allocations depending on their needs. The service connections are preconfigured with specific resource limits for CPU, memory, and I/O, which determines the level of performance and concurrency available to users.
DBNAME_HIGH is the service connection that provides the highest level of resources, making it suitable for running lots of high concurrent queries. This service connection offers the highest number of CPUs and memory, allowing users to execute complex and resource-intensive queries quickly and efficiently. Additionally, it provides a high level of parallelism, enabling multiple queries to run concurrently without being impacted by each other.
DBNAME_MEDIUM and DBNAME_LOW, on the other hand, provide lower levels of resources and are suitable for running queries with lower levels of concurrency. DBNAME_CONCURRENT provides resources that are optimized for running many small, simple queries concurrently, rather than a small number of complex queries.
In summary, DBNAME_HIGH is the best choice when running lots of high concurrent queries in Autonomous Database because it offers the highest level of resources and parallelism, enabling users to execute complex and resource-intensive queries quickly and efficiently.
