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 Data Warehouse
You are required to select a service when you connect to the database. The service names for Autonomous Data Warehouse connections are in the format: - Database Service Names for Autonomous Transaction Processing and Autonomous JSON Database
You are required to select a service when you connect to the database. The service names for connecting to Autonomous Transaction Processing or Autonomous JSON Database are in the format: - 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_classvalues to use with Oracle Scheduler.
Parent topic: Monitor and Manage Performance