Real-Time SQL Monitor Window

The Real-Time SQL Monitor Window allows you to view the performance of SQL and PL/SQL that is currently or has previously been executed. You can also view an Active Report Window for individual SQL statements or PL/SQL blocks.

Opening the Real-Time SQL Monitor Window

You can open the Real-Time SQL Monitor Window by clicking the Real-Time SQL Monitor menu item on a Data Connection Nodes.

Using the Real-Time SQL Monitor Window

The Real-Time Monitor Window contains various toolbar icons and SQL IDs that can be clicked on. You may also hover over different grid cells to view additional information about a monitoring task.

The Real-Time SQL Monitor Window appears as follows:

The Real-Time SQL Monitor Window has the following controls:

Control	Description
Freeze Content	Temporarily stops refreshing of the content.
Save Selected Report	Saves an Active Report or XML SQL Monitor Report for SQL or PL/SQL associated the selected row.
Activity Last	Select the timeframe for which you wish to display the monitored SQL
Top 100 by	Choose the metric you wish to use to sort the results
Auto Refresh	Select the frequency with which the results should be auto refreshed. Select Off to disable auto refresh.
Refresh	Manually refresh the results
Column Header	Click any column header to sort that metric in ascending order. Click again to sort by that metric in descending order.
SQL ID	Click any SQL ID to open an Active Report for that SQL.