Enable or Disable Auto Scaling of an Autonomous Database on Dedicated Exadata Infrastructure

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. Click Edit under Resource Allocation. The page to manage resources is opened.
  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.

    Note:

    You can also open the page to enable or disable auto-scaling in another way. On Oracle Public Cloud, Click Manage resource allocation. On Exadata Cloud@Customer, Click Manage scaling.
  4. Submit the details and apply your changes.

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;