Oracle Cloud Infrastructure Documentation

Scale the DB System

You can perfrom various scaling operations on a DB system.

Scale the CPU Cores for a Bare Metal DB System

If a bare metal DB system requires more compute node processing power, you can scale up (increase) the number of enabled CPU cores in the system without impacting the availability of that system.

Note

You cannot change the number of CPU cores for a virtual machine DB system in the same way. Instead, you must change the shape to one with a different number of OCPUs. For more information, see Change the Shape of a DB System.

  1. Open the navigation menu. Select Oracle Database, then select Oracle Base Database.
  2. Choose your Compartment. A list of database systems is displayed.
  3. In the list of DB systems, find the system you want to scale and click its highlighted name.

    The system details are displayed.

  4. Click Scale CPU cores, and then change the number in the CPU core count field. The text below the field indicates the acceptable values, based on the shape used when the DB system was launched.
  5. Click Update.

Scale Up the Storage for a Virtual Machine DB System

If a virtual machine DB system requires more block storage, you can increase the storage at any time without impacting the system.

Limitations

If you are scaling either data storage or recovery area storage from a value less than 10,240 GB (10 TB) to a value exceeding 10,240 GB, perform the scaling in two operations. First, scale the system to 10,240 GB. After this first scaling operation is complete and the system is in the "available" state, perform a second scaling operation, specifying your target storage value above 10,240 GB. Attempting to scale from a value less than 10,240 GB to a value higher than 10,240 GB in a single operation can lead to a failure of the scaling operation.

Procedure

  1. Open the navigation menu. Select Oracle Database, then select Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, find the system you want to scale up and click its highlighted name. The system details are displayed.
  4. Click Scale storage up.
  5. In the Scale storage up panel, scale your storage as needed:
    Note

    The Available storage (GB) value you specify during provisioning determines the maximum total storage available through scaling. The total storage available for each choice is detailed in the Storage Scaling Considerations for Virtual Machine Databases Using Fast Provisioning topic in the About Virtual Machine DB Systems article.

    The Choose storage management software and Configure storage performance sections display the values you had selected while provisioning and cannot be changed.

    In the Available data storage (GB), select the amount of BlockStorage in GB to allocate to the virtual machine DB system. Available storage can be scaled up as needed after provisioning your DB system.

    In the Recovery area storage (GB), select the amount of storage required for recovery log data (RECO storage). The recovery area storage is determined based on the storage selected.

    The read-only Total storage (GB) field displays the total amount of storage that will be used by the DB system, including storage required by Oracle's DB system software. The size of the backup determines the minimum value for available storage.

    The Expected theoretical max IOPS for data storage displays the maximum theoretical IOPS that is achievable for storage you have selected.

    Note

    Oracle recommends keeping recovery storage at 20% of total storage or higher. Oracle charges for the total storage used, including data storage, recovery storage, and storage required for the system software.
  6. Click Update.