Oracle Cloud Infrastructure Documentation

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

  1. Go to the Details page of the Autonomous Database for which you want to enable or disable auto scaling.
    Note

    For databases that use Autonomous Data Guard, go to the Details page of the primary database.

    For instructions, see View Details of an Autonomous Database on Dedicated Exadata Infrastructure.

  2. For Autonomous Database on Oracle Public Cloud, select Manage Scaling on the Details page. For Autonomous Database on Exadata Cloud@Customer, select Scale Up/Down on the Details page.
  3. To enable auto scaling, select the check-box next to OCPU auto scaling or ECPU auto scaling. If this check-box is pre-selected, deselecting it will disable auto scaling.

    Tip:

    The CPU type, that is, OCPU or ECPU is determined by the compute model of the parent Autonomous Exadata VM Cluster. See Compute Models in Autonomous Database for more details.
  4. Click Update to save your change.

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;