1. Using Guide for Oracle Cloud
  2. Monitoring
  3. The Monitoring Pages
  4. The Database Dashboard Page
  5. Database Dashboard Activity

Database Dashboard Activity

The Monitor tab shows real-time and historical information about the Autonomous Database performance data, activity, and utilization.

Note:

The default view in the Monitor tab is real-time. This view shows performance data for the last hour.

The charts on this page are:

  • Database Activity

    This chart shows the average number of sessions in the database using CPU or waiting on a wait event. See Oracle Database Reference for more information on wait events.

  • CPU Utilization (with ECPU compute model)

    This chart shows the CPU utilization of each consumer group. The utilization percentage is reported with respect to the number of CPUs the database is allowed to use which is the number of ECPUs. For example, if the database has four (4) ECPUs, the percentage in this graph is based on 4 CPUs.

    For databases with compute auto scaling enabled the utilization percentage is reported with respect to the maximum number of CPUs the database is allowed to use, which is three times the number of ECPUs. For example, if the database has four ECPUs with auto scaling enabled, the percentage in this graph is based on 12 CPUs.

    See Manage Concurrency and Priorities on Autonomous Database for detailed information on consumer groups.

  • CPU Utilization (with OCPU compute model)

    This chart shows the CPU utilization of each consumer group. The utilization percentage is reported with respect to the number of CPUs the database is allowed to use which is two times the number of OCPUs. For example, if the database has four (4) OCPUs, the percentage in this graph is based on 8 CPUs.

    For databases with compute auto scaling enabled the utilization percentage is reported with respect to the maximum number of CPUs the database is allowed to use, which is six times the number of OCPUs. For example, if the database has four OCPUs with auto scaling enabled the percentage in this graph is based on 24 CPUs.

    See Manage Concurrency and Priorities on Autonomous Database for detailed information on consumer groups.

  • Running Statements

    This chart shows the average number of running SQL statements in each consumer group.

    See Manage Concurrency and Priorities on Autonomous Database for detailed information on consumer groups.

  • Queued Statements

    This chart shows the average number of queued SQL statements in each consumer group.

    See Manage Concurrency and Priorities on Autonomous Database for detailed information on consumer groups.

To see earlier data click Time period. The default retention period for performance data is thirty (30) days. By default in the Time Period view the charts show information for the last eight (8) days.

In the time period view you can use the calendar to look at a specific time period in the past 30 days. You can also use the time slider to change the period for which performance data is shown.

Note:

The retention time can be changed by changing the Automatic Workload Repository retention setting with the PL/SQL procedure DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS. Be aware that increasing the retention time results in more storage usage for performance data. See Oracle Database PL/SQL Packages and Types Reference.