Oracle Cloud Infrastructure Documentation

Using Database Metrics

Oracle Pulse shows key metrics for each database in the selected environment.

To see database metrics for the environment, select Database from the list in the upper left corner of the Performance dashboard.

Each record in the table shows the following information for the corresponding database:

  • Avg Current Logons Count: This metric represents the current number of logons. The table shows the average number of logons over the last 24 hours.

  • Avg Global Cache Avg CR Block Req Time (centisec): This metric represents the average time that the current request (CR) block was received, measured in 100ths of a second. The table shows the average time over the last 24 hours.

    Note

    This metric is available only for RAC node databases.

  • Avg Network Bytes (per sec): This metric represents the total number of bytes sent and received through the SQL Net layer to and from the database. The table shows the average number of bytes over the last 24 hours.

  • Avg Physical Writes (per sec): This metric represents the number of data blocks written to the disk per second during this sample period. The table shows the average number of data blocks over the last 24 hours.

  • Avg Process Limit Util (%): This metric checks for the utilization of the process resource against the values (percentage) specified by the threshold arguments. The table shows the average utilization over the last 24 hours.

  • Avg Session Limit Util (%): This metric checks for the utilization of the session resource against the values (percentage) specified by the threshold arguments. The table shows the average utilization over the last 24 hours.

  • Avg Session Logical Reads (per sec): This metric represents the number of logical reads per second during the sample period. The table shows the average number of reads over the last 24 hours.

  • Avg Total Mem Util (MB): This metric displays the total amount of memory used, in MB. The table shows the average amount of memory over the last 24 hours.

Note

For more information, see 1.2.1 How to Analyze Host Metrics in the Oracle Fusion Applications Performance and Tuning Guide.

Use the table to:

Using Database Metrics Charts

The Performance dashboard also displays graphical representations with detailed information about the corresponding database metric. By default, the chart corresponding to the first metric and database for which there is available data is displayed. However, charts cannot be displayed for metrics and databases marked with NA, for which there is no data available.

Chart View: The chart view provides a visual representation of the data collected for the database metric, over the specified time interval:

  • Custom Timeframe: Use this option to show the data collected over a time interval of your choice for a period of up to 3 full months, as explained in the Using the Widget Time Selector section in Working with Oracle Pulse.

  • Last 24 hours: Use this option to show the data collected over the last 24 hours. By default, data is collected every 5 minutes.

    This is the default option. Click the other tabs to see the data collected for your desired time interval.

  • Last 7 days: Use this option to show the data collected over the last 7 days. By default, data is collected every hour.

  • Last 30 days: Use this option to show the data collected over the last 30 days. By default, data is collected every day, at the same time.

  • Last 90 days: Use this option to show the data collected over the last 90 days.

Click the legend items to control the information subject to the report.

Click Open Table View in the lower right corner of the chart to open the table view in expanded mode.

Table View: The table view provides detailed information about the selected metric:

  • Date & Time: Specifies the date and time (GMT time zone) when the data was collected from Oracle® Enterprise Manager.

  • Database Environment: Specifies the database the data was collected for.

  • Metric: Specifies the name of the metric.

  • Value: Specifies the metric value at the date and time when the data was collected from Oracle® Enterprise Manager.

    Note

    This column is only available for the Last 24 Hours report.

  • Avg.: Specifies the average metric value across the selected time interval.

    Note

    This column is only available for the Last 7 days, Last 30 days, and Last 90 days reports, as well as for reports generated for a custom time period.

  • Max.: Specifies the maximum metric value recorded across the selected time interval.

    Note

    This column is only available for the Last 7 days, Last 30 days, and Last 90 days reports, as well as for reports generated for a custom time period.

  • Min.: Specifies the minimum metric value recorded across the selected time interval.

    Note

    This column is only available for the Last 7 days, Last 30 days, and Last 90 days reports, as well as for reports generated for a custom time period.

  • Std. Deviation: Specifies the amount of variation or dispersion of a set of data values.

    Note

    This column is only available for the Last 7 days, Last 30 days, and Last 90 days reports, as well as for reports generated for a custom time period.

Use the table view to: