Monitor Database Performance with Performance Hub

You can use Performance Hub to monitor your databases for defined time periods and download statistical reports. Performance Hub lets you view real-time and historical performance data for an Autonomous Database.

Tip:

To try out Performance Hub, you can go through Lab 10: Managing Database Performance in the Oracle Autonomous Database Dedicated for Developers and Database Users Workshop.

You can access Performance Hub from the Autonomous Database Details page. To access Performance Hub:

  1. Go to the Details page of the Autonomous Database you want to monitor with Performance Hub.

    For instructions, see View Details of a Dedicated Autonomous Database.

  2. On the Details page, click Performance Hub.

Performance Hub provides the following options to monitor database activity, diagnose issues, and tune queries to improve the performance of your database.

Name Description
Quick Select

Used to quickly set the time range to Last Hour, Last 8 Hours, Last 24 Hours, or Last Week.
Time Range

Use the date selector to set the time range for Performance Hub to monitor.
Time Zone

Select an entry from this list to to have all times based on UTC (Coordinated Universal Time) time, your local web browser time, or the time zone setting of the database.
Activity Summary

The Activity Summary (Average Active Sessions) timeline shows active sessions during the selected time range. It displays the average number of active sessions broken down by CPU, User I/O, and Wait. It also shows the Max CPU usage.

You can hide or show the activity summary timeline by selecting or deselecting Hide Activity Summary located next to Time Zone above this timeline.

Reports

The Reports drop down menu is used to view the Automatic Workload Repository (AWR) report.

The AWR report collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database.

An AWR report shows data captured between two points in time (or snapshots).

AWR reports are divided into multiple sections. The content of the report contains the workload profile of the system for the selected range of snapshots.

The HTML report includes links that you can use to navigate quickly between sections.
Active Session History (ASH) Analytics

The ASH Analytics tab is displayed by default. It shows Active Session History (ASH) analytics charts to explore the Active Session History data.

You can drill down into database performance across multiple dimensions such as Consumer Group, Wait Class, SQL ID, and User Name. Select an Average Active Sessions dimension and view the top activity for that dimension for the selected time period.

For more information, see ASH Analytics.

SQL Monitoring

The SQL statements are only monitored if they've been running for at least five seconds or if they're run in parallel. The table displays monitored SQL statement executions by dimensions including Last Active Time, CPU Time, and Database Time. The table displays currently running SQL statements and SQL statements that completed, failed, or were terminated. The columns in the table provide information for monitored SQL statements including Status, Duration, and SQL ID.

For more information, see SQL Monitoring.

Automatic Database Diagnostic Monitor (ADDM)

The ADDM tab provides access to analysis information gathered by the Automatic Database Diagnostic Monitor (ADDM) tool.

ADDM analyzes AWR (Automatic Workload Repository) snapshots on a regular basis, locates root causes of any performance problems, provides recommendations for correcting the problems, and identifies non-problem areas of the system.

AWR is a repository of historical performance data, therefore ADDM can analyze performance issues after the event, often saving time and resources in reproducing a problem.

For more information, see Automatic Database Diagnostic Monitor (ADDM).

Workload

Use the Workload tab to visually monitor the database workload to identify spikes and bottlenecks.

This tab shows four chart areas that show database workload in various ways:
  • CPU Statistics: Charts CPU usage.
  • Wait Time Statistics: Shows the wait time across the database's foreground sessions, divided by wait classes.
  • Workload Profile: Charts user (client) workload on the database.
  • Sessions: Shows the number of sessions, successful logons, and current logons.

For more information, see Workload.

Blocking Sessions

This tab hierarchically lists sessions that are waiting or are blocked by sessions that are waiting. You can set the minimum wait time required for sessions to be displayed in the list, and you can view a variety of information about a session to determine whether to let it continue or to kill it.

For more information, see Blocking Sessions.

For detailed guidance on viewing and monitoring your database performance using Performance Hub, refer to Using Performance Hub to Analyze Database Performance.

Related Topics