Add CPU or Storage Resources or Enable Auto Scaling
Describes how to scale your Autonomous Database on demand by adding CPU cores or storage. Also describes how to enable auto scaling.
Perform the following prerequisite steps as necessary:
-
Open the Oracle Cloud Infrastructure Console by clicking the
next to Oracle Cloud.
- From the Oracle Cloud Infrastructure left navigation menu click Oracle Database and then, depending on your workload click one of: Autonomous Data Warehouse, Autonomous JSON Database, or Autonomous Transaction Processing.
-
On the Autonomous Databases page select an Autonomous Database from the links under the Display name column.
When you click Apply with a resource change, the Lifecycle State changes to Scaling in Progress.... After the Lifecycle State changes to Available the changes apply immediately.
Note the following for adding storage resources or changing the Storage auto scaling value:
-
Autonomous Database uses Exadata Smart Flash Cache to automatically cache frequently accessed data, delivering the high I/O rates and fast response times of flash. The amount of flash cache for your database depends on the amount of storage you provision, or the amount of allocated storage if you enable storage auto scaling.
With storage auto scaling disabled, the guaranteed minimum flash cache size is 10% of your database's provisioned storage size.
With storage auto scaling enabled, the guaranteed minimum flash cache size is 10% of your database's provisioned base storage size or its allocated storage size, whichever is higher.
Parent topic: Update Compute and storage limits