Oracle Cloud Infrastructure Documentation

Analyze Available Memory Resources

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

Memory usage information is not available for Autonomous AI Databases Serverless.

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
    • LH-D: Autonomous AI Lakehouse Dedicated
    • LH-S: Autonomous AI Lakehouse Serverless (Memory metrics are not available)
    • LH-C@C: Autonomous AI Lakehouse - Dedicated on Cloud@Customer
    • External LH: External Autonomous AI Lakehouse
    • ATP-D: Autonomous AI Transaction Processing - Dedicated
    • ATP-S: Autonomous AI Transaction Processing - Serverless (Memory metrics are not available)
    • ATP-C@C: Autonomous AI Transaction Processing - Dedicated on Cloud@Customer
    • External ATP: External Autonomous AI Transaction Processing
    • AJD-D: Autonomous AI JSON Database Dedicated
    • AJD-S: Autonomous AI JSON Database Serverless
    • AJD-C@C: Autonomous AI JSON Database - Dedicated on Cloud@Customer
    • APEX-D: Autonomous AI Database for APEX Dedicated
    • APEX-S: Autonomous AI Database for APEX Serverless
    • APEX-C@C: Autonomous AI Database for APEX - Dedicated on Cloud@Customer
    • 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-C@C PDB: Exadata Database Service on Cloud@Customer Pluggable Database
    • ExaDB-C@C NonCDB: Exadata Database Service on Cloud@Customer Non-container 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: MySQL HeatWave Database Systems and external MySQL Database Systems
    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 (GB): 90th percentile value of the daily average memory usage over the selected time period
  • Capacity (GB): Maximum memory allocation observed for the selected usage range.
  • 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: