Enable or Disable Auto Scaling of an Autonomous Database
Auto scaling enables a database to use up to three times more CPU and IO resources than its specified CPU count. When auto scaling is enabled, if your workload requires additional CPU and IO resources the database automatically uses the resources without any manual intervention required.
Required IAM Permissions
use autonomous-databases
Procedure
Tip:
Enter the following SQL commands to view:- The number of ECPUs the database is currently using:
SELECT AVG_RUNNING_SESSIONS FROM V$RSRCPDBMETRIC;
- The number of OCPUs the database is currently using:
SELECT AVG_RUNNING_SESSIONS/2 FROM V$RSRCPDBMETRIC;
Parent topic: Create and Manage Dedicated Autonomous Databases