Monitor and Manage an Autonomous Database

You can monitor and manage a single Autonomous Database using Database Management Diagnostics & Management.

The information about an Autonomous Database in your fleet is displayed on the corresponding Managed database details page. To go to the Managed database details page, you can use one of the following options on the Oracle Database fleet summary page:

  • Click the name of the Autonomous Database in the Members list or table.
  • Click the rectangle denoting the Autonomous Database on the Performance tree map.

On the Managed database details page, you can:

  • Click Performance Hub to go to Performance Hub and analyze and tune the performance of the Autonomous Database. For information, see About Performance Hub.
    Note

    For Autonomous Databases, Performance Hub can also be accessed from the Autonomous Database details page.
  • Click Dashboards and then click Autonomous Database Performance to view the Oracle-defined Autonomous Database Performance dashboard that displays critical performance metrics. For information, see Autonomous Database Performance.
  • Click Add tags to add tags to the Autonomous Database. For information, see Working with Resource Tags.
  • Click one of the following options to go to the Oracle Cloud Infrastructure Ops Insights service and use its features to obtain insights into the capacity needs, resource utilization and SQL performance trends of the Autonomous Database:
    • Capacity Planning: Provides insight into the resource and usage of the database, thereby allowing you to meet both peak and long-term database capacity. For information, see Analyze Database Resources.
    • SQL Warehouse: Provides trends and key insights into SQL performance issues and enables you to perform fine-grained data analysis to optimize SQL performance. For information, see Analyze SQL Performance.

    When you click the links to access Ops Insights features, the data displayed on the Capacity Planning and SQL Warehouse pages is in the context of the Autonomous Database if Ops Insights is enabled for the database. If Ops Insights is not enabled for the database, then a message is displayed with the option to enable Ops Insights and use its features.

  • Click Log Explorer to go to the Oracle Cloud Infrastructure Logging Analytics service and view the database logs in Log Explorer. The data displayed in Log Explorer is in the context of the Autonomous Database, if Logging Analytics is enabled for the database. If Logging Analytics is not enabled for the database, then a message is displayed with information on how to enable it and use its features. For information, see Set Up Database Instance Monitoring.
  • View Managed database information, which includes details such as the database type and version, and deployment type. In the Managed database information section, you can:
    • Click the More details link in this section to view more details about the database such as the compartment name and ID.
    • Monitor the total number of open alarms and the number of alarms by severity for the Autonomous Database. Note that the alarms are only displayed on Database Management Diagnostics & Management pages, if the OCID of the database is specified using the resourceId dimension when creating the alarm. You can click the number of alarms to access the Alarms panel and review the list of open alarms. For information, see Monitor Alarms for Managed Databases.

      Click Manage alarm definitions to go to the Alarm definitions section and perform tasks such as creating Oracle-recommended alarms and editing alarm values. For information, see Set Up Alarm Definitions.

  • Click the Tags tab to add, view, edit, or remove tags. For information, see Working with Resource Tags.
  • Monitor database performance attributes in the Summary section for the time period selected in the Time period drop-down list. Last 60 min is the default time period, and the visual representations or charts in the Summary section provide a quick insight into the health of your database during the selected time period and enable you to analyze data better. You can hover the mouse on the charts to view additional details; and filter the data displayed in the charts by clicking the dimensions displayed in the legend.
    • Activity class (Avg. Active Sessions): Displays the average active sessions in the selected time period, broken down by CPU, User I/O, and Wait for Autonomous Database on Dedicated Exadata Infrastructure and CPU and Wait for Autonomous Databases Serverless. The maximum CPU threads limit is denoted by a red line.
    • Activity: Displays the percentage of CPU utilization, and DB time.
    • I/O: Displays the I/O throughput in MBPS and I/O rate in IOPS broken down by Read and Write operations.
      Note

      The I/O chart is not displayed for Autonomous Database Serverless.
    • Storage usage: Displays System storage and User data storage in TB. System storage is broken down by usage in system tablespaces and user data, and User data storage is broken down by usage in the top five user tablespaces. The total storage allocation for the database is denoted by a red line and enables you to monitor storage usage compared to the total allocation.
      Note

      The Storage usage chart is not displayed for Autonomous Database Serverless, and in its place, allocated and used storage information is displayed in a Storage chart.
    • SQL statements: Displays the number of queued and running SQL statements.
    • Failed connections: Displays the number of failed database connections.
      Note

      The Failed connections chart is not displayed for Autonomous Database on Dedicated Exadata Infrastructure.

The Summary section is displayed by default on the Managed database details page of an Autonomous Database, however, you can click one of the other options on the left pane under Resources to perform the following tasks:

  • Associated database groups: View the Database Groups the Autonomous Database is a part of, if any. For information, see Create and Use Database Groups.
  • Alarm definitions: Create Oracle-recommended alarms and perform other alarm-related tasks in Database Management. For information, see Set Up Alarm Definitions.