Oracle Cloud Infrastructure Documentation

Analyze Available Memory Resources

For a complete view of memory usage across all Ops Insights enabled databases, click Memory under Resources in the left navigation menu.
Note

Memory is only applicable for external databases.

By default, you view comprehensive memory usage for each database. Viewing the memory utilization 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
    • 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.
  • Utilization (%):Utilization percentage for the 90th percentile value of the daily average memory usage over the selected time period
  • Usage Change (%): Percentage change in the linear trend of memory usage over the selected time period
  • Usage (TB): 90th percentile value of the daily average memory usage over the selected time period
  • Allocation (TB): Allocation for the 90th percentile value of the daily average memory 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.

Analyze Trend and Forecast Memory Usage

Selecting a database from the memory usage table, you can view memory consumption as well as the trend and usage forecast for that database. By default, trending and forecasting are calculated using linear regression. For more advanced analysis, you can have Ops Insights use machine learning to perform the trending and forecasting.

Memory 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: