Monitoring Databases with Performance Hub

Use Performance Hub to monitor database activity, diagnose issues, and tune queries to improve the performance of Oracle databases.

You can use Performance Hub to view real-time and historical performance data for a database. Performance Hub shows Active Session History (ASH) analytics, SQL monitoring and workload information.

SQL Monitoring

The SQL Monitoring tab contains a table that displays monitored SQL statements. To view this tab, click SQL Monitoring on the Performance Hub page.

The table in the SQL Monitoring tab displays SQL statement executions by dimensions, such as Last Active Time, CPU Time, Database Time, and so on. It not only provides information about SQL statements that are currently running but also SQL statements that completed, failed, or were terminated. The table consists of columns that include Status, Duration, SQL ID, and so on for monitored SQL statements.

Note:

SQL statements are monitored only if they have been running for at least five seconds or if they are run in parallel.

The Status column includes the following icons:

• A spinning icon indicates that the SQL statement is running.

• A green check mark icon indicates that the SQL statement completed its execution during the specified time period.

• A red cross icon indicates that the SQL statement did not complete. The icon displays when an error occurs because the session was terminated.

• A clock icon indicates that the SQL statement is queued.

You can kill session to terminate a running or queued SQL statement.

For more information, see:

• unresolvable-reference.html#GUID-D678E43F-F931-497A-BD8E-792416945426

Real-time SQL Monitoring

You can also click an SQL ID to go to the corresponding Real-time SQL Monitoring page. This page provides additional details that helps you tune the selected SQL statement.

For more information, see:

• unresolvable-reference.html#GUID-3883960C-8D69-47B8-94EC-AEA4A62CBE64

View Real-time SQL Data from SQL Monitoring

1. On the Performance Hub page, click SQL Monitoring to display the SQL monitoring tab.

2. In the SQL ID column, click an ID to display detailed information about the specific SQL statement execution.

   This action displays the Performance Hub Real-time SQL Monitoring page.

3. Scroll down to display the SQL activities.

   Depending on the database selected, the Details section includes Plan Statistics, Parallel, SQL Text, and Activity tabs.

   In the Details section of the page:

   • Click Plan Statistics to view the Tabular Execution Plan and Graphical Explain Plan.

   • Click Parallel to view the Parallel Server and the Instances and Parallel Groups it contains.

   • Click SQL Text to view the text of the active SQL query.

   • Click Activity to view the active sessions of the database that is selected.

     Use the menu on the details page to view either the Active Sessions Resource Type or Plan Line of the selected SQL operation.

4. Click the Back arrow at the top-left corner of the page to go back to the SQL Monitoring tab.