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. On Oracle Public Cloud, click Edit in the Resource Allocation section. On Exadata Cloud@Customer, click Edit in the Resources section. The Manage scaling page opens.
  3. To enable auto scaling, select the check-box next to Compute auto scaling for ECPU count or OCPU count. If this check-box is pre-selected, deselecting it will disable auto scaling.

    Tip:

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

    Note:

    Alternatively, you can open Manage scaling page by clicking Manage resource allocation on Oracle Public Cloud or Manage scaling on Exadata Cloud@Customer.
  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;