Manage Concurrency and Priorities on Autonomous Database
Concurrency and prioritization of user requests in Autonomous Database is determined by the database service the user is connected with, and whether compute auto scaling is enabled.
- Database Service Names for Autonomous Database
Autonomous Database comes with predefined database services with different performance and concurrency characteristics. You must choose one of these services for each application or user that connects to the database. - Idle Time Limits
Autonomous Database has predefined idle time limits for sessions so that idle sessions do not hold system resources for a long time. - Service Concurrency
The consumer groups of the predefined service names provide different levels of performance and concurrency. The available service names are different depending on your workload: Data Warehouse, Transaction Processing, or JSON Database. - Change MEDIUM Service Concurrency Limit (ECPU Compute Model)
If your application requires customized concurrency, you can modify the concurrency limit for your Autonomous Database MEDIUM service. - Change MEDIUM Service Concurrency Limit (OCPU Compute Model)
If your application requires customized concurrency, you can modify the concurrency limit for your Autonomous Database MEDIUM service. - Predefined Job Classes with Oracle Scheduler
Autonomous Database includes predefinedjob_class
values to use with Oracle Scheduler.
Parent topic: Monitor and Manage Performance