Compare CPU Utilization Between Databases

The CPU breakdown by individual databases chart lets you compare how your different, individual databases are using their resources.

1. Click the Group By list to select the metrics by which you want to group the databases.

   • Life Cycle Status

   • Target Version

   • Cost Center

   • Host Name

   • Contact

   • Database Type

2. To view the 10 databases consuming the most CPU resources, from the Group by list, select Top 10.
3. To view the CPU consumption split on the basis of the pluggable databases, select Split by Pluggable Databases (Top 10).
4. Select the databases for which you want to view specific information.
5. To view the list of databases, and their relevant information like the DB type, CPU used, change %, hostname, target version, life cycle, and cost center in a CSV format, click Download CSV.

The number of database processes run on the CPU, and the percentage change are represented visually, through the size and color of the cells, respectively. Cells that are larger in size run more database processes than smaller cells. The largest cell would be that of the databases using the most CPU resources. The color of the cells is determined by the percentage change in the CPU resources used by the databases.