OCI: How To Change DB System Shape in VMBM (Doc ID 2827920.1)

Last updated on JANUARY 23, 2022

Applies to:

Goal

How To Change DB System Shape in VMBM.?
 

After you provision a virtual machine DB system, you can change the shape at any time to adapt to changes in performance needs. For example, you might require a system with a higher number of OCPUs, or you might want to reduce costs by reducing the number of OCPUs.

See Virtual Machine DB Systems for resource details for each shape in a series.

  - https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/overview.htm#vmShapes

 Changing the shape does not impact the amount of storage available to the DB system. However, the new shape can have different memory and network bandwidth characteristics, and you might need to reapply any customizations to these aspects after the change.

Prerequisites:

• DB system and database are in the Available state
• DB system is registered with the Cluster Ready Services (CRS) Grid Infrastructure stack. By default, virtual machine DB systems use CRS.
• Database can be successfully restarted
• Database is configured to use SPFILE (server parameter file), not PFILE. By default, databases in virtual machine DB systems use the SPFILE configuration.
• The SGA_TARGET parameter for Automatic Shared Memory Management (ASMM) has a non-zero value. By default, virtual machine DB systems use this ASMM configuration.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.