Change the Shape of a DB System
After you provision a DB system, you can change the shape at any time to adapt to changes in performance requirements. For example, you might require a system with more number of OCPUs, or you might want to reduce costs by reducing the number of OCPUs.
The shape-changer operation takes place in a rolling fashion for multi-node RAC DB systems, allowing you to change the shape with no database downtime.
Changing the shape does not affect the amount of storage available to the DB system. However, the new shape can have different memory and network bandwidth characteristics, and you can 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, the DB systems use CRS.
- Database can be successfully restarted.
- Database is configured to use SPFILE (server parameter file), not PFILE. By default, databases in the DB systems use the SPFILE configuration.
- The
SGA_TARGET
parameter for Automatic Shared Memory Management (ASMM) has a nonzero value. By default, the DB systems use this ASMM configuration.
Migration from Intel to AMD Shapes
You can now migrate your DB system from Intel-based X7 shapes to AMD E4 shape by using the Change shape operation. The following prerequisites and restrictions apply to the migration of DB systems.
Migration from Intel shapes to AMD E5 shape is currently not supported.
- The DB system must use the kernel UEK5. If the DB system is on UEK4, the migration operation will automatically update it to UEK5.
- The DB system must use Oracle Linux 7 (OL7). If a DB system is running on a version below OL7, you must upgrade the DB system to OL7 before migration.
- The DB system must use an Oracle Grid Infrastructure version later than or equal to 19.15.
- The DB system must use the following Oracle Database versions or
later versions for respective database version series.
- 23.4.0.24.05
- 21.6.0.0.0
- 19.15.0.0.0
- 12.2.0.1.220418
- 12.1.0.2.220419
- The DB systems based on Oracle Database 11.2 cannot be migrated.
- You can migrate from Intel-based 2.X to AMD-based X OCPUs only. For example, if you are in the Intel VM.Standard2.2 shape, you will be able to migrate to the AMD 2 OCPU shape. However, after you have migrated, you will be able to change the AMD shape OCPUs according to the available options.
- After migrating to an AMD shape, you can scale up the storage to a maximum of 40 TB (the maximum allowed storage options available on Intel X7 shapes).
- After migration to an AMD shape, you will be on the balanced storage volume performance option. You will not be able to change to the Higher performance option.
- While creating a clone for a migrated DB system, the clone will have the same characteristics as the migrated DB system.
- While creating Oracle Data Guard for a database in a migrated DB system, the standby will have the same characteristics as the migrated DB system.
- After successful migration, you will not be able to migrate back from AMD to Intel shapes.
- After successful migration, you will not be able to restore to an old boot volume backup.
Procedure
Shape change to and from AMD E5 flexible shape is currently not supported.
- Open the navigation menu. Select Oracle Database, then select Oracle Base Database Service.
- Select your Compartment. A list of DB systems is displayed.
- In the list of DB systems, find the system you want to scale and click its highlighted name. The system details are displayed.
- Click Change shape, and select an available shape from the list. For a complete list of shapes, see Available Shapes and How It Determines the Resources Allocated.
- The Shape series section display the values you had selected
while provisioning and cannot be changed.
Note
If you are changing the shape from Intel-based X7 shapes to AMD-based flexible shape E4, then the number of OCPUs cannot be changed. You can migrate from Intel-based 2.X to AMD-based X OCPUs only. For example, if you are in the Intel VM.Standard2.2 shape, you will be able to migrate to the AMD 2 OCPU shape. However, after you have migrated, you will be able to change the AMD shape OCPUs according to the available options. - Configure OCPU: Select the number of
OCPUs you want to allocate to this instance. For Ampere A1, AMD E4, AMD E5, and
Intel X9 flexible shapes, you can select the number of OCPUs by using the slider
in the Number of OCPUs per node field.
- For Ampere A1 shape, a minimum of 1 OCPU and a maximum of 57 OCPUs can be selected.
- For AMD E4 and E5 shapes, a minimum of 1 OCPU and a maximum of 64 OCPUs can be selected.
- For Intel X9 shape, a minimum of 1 OCPU and a maximum of 32 OCPUs can be selected.
The following resources scale proportionately to the number of OCPUs you selected.
- Memory (GB): The amount of memory you want to
allocate to this instance.
For Ampere A1, AMD E4, AMD E5, and Intel X9 shapes, the memory will scale proportionally based on the number of OCPUs selected.
- For Ampere A1 shape, for each OCPU, 8 GB of memory is allocated. A minimum of 8 GB and a maximum of 456 GB of memory is allocated.
- For AMD E4 and E5 shapes, for each OCPU, 16 GB of memory is allocated. A minimum of 16 GB and a maximum of 1024 GB of memory is allocated.
- For Intel X9 shape, for each OCPU, 16 GB of memory is allocated. A minimum of 16 GB and a maximum of 512 GB of memory is allocated.
- Network bandwidth (Gbps): The amount of network
bandwidth you want to allocate to this instance.
For Ampere A1, AMD E4, AMD E5, and Intel X9 shapes, the bandwidth will scale proportionally based on the number of OCPUs selected. For each OCPU, 1 Gbps of network bandwidth is allocated.
- For Ampere A1 shape, a minimum of 1 Gbps and a maximum of 40 Gbps of network bandwidth is allocated.
- For AMD E4 and E5 shapes, a minimum of 1 Gbps and a maximum of 40 Gbps of network bandwidth is allocated.
- For Intel X9 shape, a minimum of 1 Gbps and a maximum of 32 Gbps of network bandwidth is allocated.
- Theoretical max IOPS: The amount of input and output
per second (IOPS) you want to allocate to this instance. Theoretical max
IOPS is also dependent on the storage you select.
For Ampere A1, AMD E4, AMD E5, and Intel X9 shapes, the theoretical max IOPS will scale proportionally based on the number of OCPUs selected. For each OCPU, 16K theoretical max IOPS is allocated.
- For Ampere A1 shape, a minimum of 16K and a maximum of 640K theoretical max IOPS is allocated.
- For AMD E4 and E5 shapes, a minimum of 16K and a maximum of 640K theoretical max IOPS is allocated.
- For Intel X9 shape, a minimum of 16K to a maximum of 512K theoretical max IOPS is allocated.
- Review the information about the confirmation dialog, and click
Change shape.
Note
Changing shape requires a restart.
Tip:
If your shape change operation is not successful, see troubleshooting tips in the Troubleshoot Shape Change Failures article.