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

Database Dashboard Overview

The Overview tab shows real-time and historical information about the Autonomous Database utilization.

The charts shown on this page include:

  • Storage: This chart shows the provisioned, allocated, and used storage. The chart indicates what percentage of the space is currently in-use.

    Description of adb_console_overview_storage.png follows
    Description of the illustration adb_console_overview_storage.png

    Provisioned storage is the amount of storage you select when you provision the instance or when you modify storage by scaling storage.

    Storage allocated is the amount of storage physically allocated to all data tablespaces and temporary tablespaces and includes the free space in these tablespaces. This does not include storage for the sample schemas.

    Storage used is the amount of storage actually used in all data and temporary tablespaces. This does not include storage for the sample schemas. The storage used is the storage in the Autonomous Database as follows:

    • Storage used by all database objects. Note: the chart does not include storage for the sample schemas as they do not count against your storage.
    • Storage for files users put in the file system.
    • Storage used by temporary tablespaces.
    • Used storage excludes the free space in the data and temporary tablespaces.

    By default the chart does not show the used storage. Select Storage used to expand the chart to see used storage (the values are calculated when you open the chart).

    For an Autonomous JSON Database the chart shows an additional field showing the percentage of storage used that is not storing JSON documents.

    Note:

    If you drop an object, the space continues to be consumed until you empty the recycle bin. See Purging Objects in the Recycle Bin for more information.

    See Use Sample Data Sets in Autonomous Database for information on sample schemas SH and SSB.

  • CPU utilization (%) for ECPU Compute Model: This chart shows the historical CPU utilization of the service:

    • Compute auto scaling disabled: this chart shows hourly data. A data point shows the average CPU utilization for that hour. For example, a data point at 10:00 shows the average CPU utilization for 9:00-10:00.

      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.

      Description of adb_console_overview_number_ocpus_noauto.png follows
      Description of the illustration adb_console_overview_number_ocpus_noauto.png

    • Compute auto scaling enabled: 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.

      Description of adb_console_overview_cpu_util.png follows
      Description of the illustration adb_console_overview_cpu_util.png

  • CPU utilization (%) for OCPU Compute Model: This chart shows the historical CPU utilization of the service:

    • Compute auto scaling disabled: this chart shows hourly data. A data point shows the average CPU utilization for that hour. For example, a data point at 10:00 shows the average CPU utilization for 9:00-10:00.

      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.

      Description of adb_console_overview_number_ocpus_noauto.png follows
      Description of the illustration adb_console_overview_number_ocpus_noauto.png

    • Compute auto scaling enabled: 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.

      Description of adb_console_overview_cpu_util.png follows
      Description of the illustration adb_console_overview_cpu_util.png

  • Running SQL statements: This chart shows the average number of running SQL statements historically. This chart shows hourly data. A data point shows the running SQL statements for that hour. For example, a data point at 10:00 shows the average number of running SQL statements for 9:00-10:00.

    Description of adb_console_overview_running_sql.png follows
    Description of the illustration adb_console_overview_running_sql.png

  • Number of ECPUs allocated (only shown for ECPU Compute Model):

    Description of adb_overview_number_ecpus.png follows
    Description of the illustration adb_overview_number_ecpus.png

    Notes for display results:

    • Compute auto scaling disabled: For databases with compute auto scaling disabled, for each hour the chart shows the number of ECPUs allocated to the database if the database is open for at least some part of the hour.
    • Compute auto scaling enabled: For databases with compute auto scaling enabled, for each hour the chart shows the average number of ECPUs used during that hour if that value is higher than the number of ECPUs provisioned. If the number of ECPUs used is not higher than the number of ECPUs provisioned, then the chart shows the number of ECPUs allocated for that hour.
    • Stopped Database: If the database was stopped for the full hour the chart shows 0 ECPUs allocated for that hour.

    Click Show details for more information, including the number of ECPUs allocated to the database and to external resources, and the total allocated ECPUs.

    The Show details view includes separate values for database ECPU usage and external resource ECPU usage. External resources include: Cloud SQL, Graph, OML4PY, and others. The Total ECPUs are the total number of ECPUs in use on the Autonomous Database. The external ECPUs value shows how external ECPUs contribute to the total ECPU usage.

  • Number of OCPUs allocated (only shown for OCPU Compute Model):

    Description of adb_console_overview_number_ocpus.png follows
    Description of the illustration adb_console_overview_number_ocpus.png

    Notes for display results:

    • Compute auto scaling disabled: For databases with compute auto scaling disabled, for each hour the chart shows the number of OCPUs allocated to the database if the database is open for at least some part of the hour.
    • Compute auto scaling enabled: For databases with compute auto scaling enabled, for each hour the chart shows the average number of OCPUs used during that hour if that value is higher than the number of OCPUs provisioned. If the number of OCPUs used is not higher than the number of OCPUs provisioned, then the chart shows the number of OCPUs allocated for that hour.
    • Stopped Database: If the database was stopped for the full hour the chart shows 0 OCPUs allocated for that hour.

    Click Show details for more information, including the number of OCPUs allocated to the database and to external resources, and the total allocated OCPUs.

    The Show details view includes separate values for database OCPU usage and external resource OCPU usage. External resources include: Cloud SQL, Graph, OML4PY, and others. The Total OCPUs are the total number of OCPUs in use on the Autonomous Database. The external OCPUs value shows how external OCPUs contribute to the total OCPU usage.

  • SQL statement response time (s): This chart shows the average response time, in seconds, of SQL statements historically. This chart shows hourly data. A data point shows the average SQL statement response time for that hour. For example, a data point at 10:00 shows the average SQL statement response time, in seconds, for the hour from 9:00-10:00.

    Description of adb_console_overview_sql_statement_response.png follows
    Description of the illustration adb_console_overview_sql_statement_response.png

  • SQL statements executed per second

    Note:

    Database Dashboard does not show this chart when the Autonomous Database instance workload type is Data Warehouse.

    .
    Description of adb_console_overview_sql_statements.png follows
    Description of the illustration adb_console_overview_sql_statements.png

The default retention period for performance data is thirty (30) days. The CPU utilization, running statements, and average SQL response time charts show data for the last eight (8) days by default.

You can change the retention period by modifying the Automatic Workload Repository retention setting with the PL/SQL procedure DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(). The maximum retention you can set is 30 days. See Oracle Database PL/SQL Packages and Types Reference.

If you need to store more performance data you can use the Operations Insights AWR Hub. See Analyze Automatic Workload Repository (AWR) Performance Data for more information.