Oracle Cloud Infrastructure Documentation

Database Metrics

Viewing the Metrics for a Database in OracleDB for Azure is accomplished from the blade for the database you wish to stop. Each blade is slightly different and so are the database details, but the process is similar.

The following steps define the primary process for viewing your database metrics. In addition to this process, there is a mechanism provided through Microsoft Azure to view metrics. That process is defined at the end of these steps to provide a secondary approach, in desired.

  1. Go to the database blade for the database you wish to view its metrics.

    Figure 1-141 Example Database Blade - Oracle Autonomous Database Serverless


    Description of Figure 1-141 follows

    Figure 1-142 Example Database Blade - Exadata Database


    Description of Figure 1-142 follows

    Figure 1-143 Example Database Blade - Base Database


    Description of Figure 1-143 follows

  2. Select the specific database you want to view from the list. This will open the details for that specific database, as shown in the example below.

    Figure 1-144 Example Database Selection - Autonomous Database


    Description of Figure 1-144 follows

    Figure 1-145 Example Database Selection - Exadata Database


    Description of Figure 1-145 follows

    Figure 1-146 Example Database Selection - Base Database


    Description of Figure 1-146 follows

  3. Select the Metrics icon. If the Metrics icon is not active, the database does not yet have viewable metrics. See Resolving the Metrics Icon Not Showing for a Database for more information.
  4. The Microsoft Azure Application Insights blade opens.
  5. You can learn more about Microsoft Azure Application Insights at About Application Insights .
  6. Select the Metrics link on the left-side menu.

    Figure 1-147 Example Application Insights Portal


    Description of Figure 1-147 follows

  7. This is the Metrics blade. You can select a variety of metrics to display. Before you can see any metrics, you must select the Metrics Namespace and the specific metric or metrics you wish to chart.
    By default, the starting Metrics Namespace is the Log-based Metrics namespace. For a Oracle Autonomous Database Serverless, an Oracle Exadata Database, a Oracle Base Database, or an Oracle HeatWave Database, you will need to select the namespace as follows:

    Table 1-1 Metrics Namespace

    Database Type Metrics Namespace
    Oracle Autonomous Database Serverless oci_autonomous_database
    Oracle Exadata Database oracle_oci_database
    Oracle Base Database oracle_oci_database
    Oracle HeatWave Database oci_mysql_database

    Figure 1-148 Example Metrics Namespace Selection


    Description of Figure 1-148 follows

  8. Select the Metric or Metrics you wish to chart.

    Figure 1-149 Example Metrics Selection


    Description of Figure 1-149 follows

  9. By default, the timeframe for the metrics is the Last 24 hours. To change this, select the timeframe selector at the top-right of the Metrics blade.

    Figure 1-150 Example Timeframe Selection


    Description of Figure 1-150 follows

    Figure 1-151 Example Expanded Timeframe


    Description of Figure 1-151 follows

  10. For any other issues, see the Database Troubleshooting guide.

Using Microsoft Azure for Database Metrics can be accomplished as follows:

  1. From anywhere in the Microsoft Azure portal, select the Azure menu (hamburger) on the top-left of the page.

    Figure 1-152 Example Accessing the Microsoft Azure Portal Menu from the Applications Insights Portal


    Description of Figure 1-152 follows

  2. From this menu, select the Dashboard entry.

    Figure 1-153 Example Selecting the Dashboard


    Description of Figure 1-153 follows

  3. The My Dashboard portal will open. Select the drop-down at the top.

    Figure 1-154 Example Select the My Dashboard Drop-down


    Description of Figure 1-154 follows

  4. From this drop-down, select the specific database you wish to view.

    Figure 1-155 Select a Specific Database


    Description of Figure 1-155 follows

  5. This is the top of the dashboard that is created, in Microsoft Azure, for your database. There are lots of useful information and functions on this dashboard. For example, you can copy the connection strings required to access the database from this part of the dashboard. For the metrics, scroll down in the dashboard.

    Figure 1-156 Example Database Dashboard


    Description of Figure 1-156 follows

  6. These are the metrics presented for your database.

    Figure 1-157 Example Database Metrics


    Description of Figure 1-157 follows