Analyze I/O Trend Over Time

To view I/O activity across all Ops Insights enabled databases, click I/O under Resources in the left navigation menu.

Note

I/O is only applicable for external databases.

By default, you view comprehensive I/O activity for each database. Viewing the I/O activity for each database lets you compare resource utilization between databases and identify servers with underused or overused resources. For each database, you view the following:

  • Database Types
    • ADW-D: Autonomous Data Warehouse Dedicated
    • ADW-S: Autonomous Data Warehouse Serverless
    • ATP-D: Autonomous Transaction Processing Dedicated
    • ATP-S: Autonomous Transaction Processing Serverless
    • External NonCDB: External Non-Container Database
    • External PDB: External Pluggable Database
    • Virtual Machine PDB: Virtual Machine Pluggable Database
    • Bare Metal PDB: Bare Metal Pluggable Database
    • ExaDB-D PDB: Exadata Database Service on Dedicated Infrastructure pluggable database
    • ExaDB-D NonCDB: Exadata Database Service on Dedicated Infrastructure non-container database
    • MySQL Database: HeatWave MySQL Database Services
    Note

    ExaDBs monitored by Enterprise Manager are also allowed.
  • Usage Change (%): Percentage change in the linear trend of I/O usage over the selected time period
  • Usage (TB): 90th percentile value of the daily average I/O usage over the selected time period
  • Allocation (TB): Allocation for the 90th percentile value of the daily average storage usage over the selected time period
  • Database Version: Version of the Oracle Database.
  • Telemetry: The source platform of the database: Cloud Infrastructure, Enterprise Manager, or Agent Service
  • Instances: The number of instances. Click on the instance number to display a list of the instance and host names.

I/O charts analysis and usage are similar to those used elsewhere in the Capacity Planning application. For an in-depth discussion about Capacity Planning charts, see: