Refine the IORM Plan
Combining the analysis from both the table data and charts provides a comprehensive understanding of the I/O utilization of the databases running on the Exadata system. If it is determined that the I/O allocations need to change, you can do it in one of the following ways:
- Change the IORM plan on the storage servers: If all the databases in the I/O Utilization history charts are stacked while showing the range and that indicates that there is significant headroom on the storage servers, you may want to increase the I/O limits and/or increase the number of I/O shares for the relevant databases. This can be accomplished by navigating to the Database Machine IORM Management page and editing the IORM plan. Oracle Enterprise Manager will then propagate this IORM plan to all the storage servers in the Exadata system.
- Reconfigure the CDB plan from the root PDB: See Creating a CDB Plan.
If all the databases are running close to their I/O limits for most of the time or are reaching peak utilization during the same time frames, there are multiple potential solutions that can be considered depending on their feasibility, including the following:
- Increase the number of storage servers on the Exadata system.
- Provision additional VMs, create additional clusters, and move databases to different clusters.
- Move PDBs to different CDBs.
- Move databases to another Exadata system.