Description of the illustration mon_sql_details_dbop.gif

This screenshot shows the Monitored SQL Execution Details: DBOP_EXAMPLE page. Next to the title of the page is a Completed symbol. At the top right of the page is the label-value pair Page Refreshed: 12:21:13 p.m GMT-0500.

The page has the Overview group and the Details group. In the Overview group are the General, Time & Wait Statistics, and IO Statistics groups.

The General group has the following label-value pairs:

Execution Started: Tue Sep 18, 2012 2:45:27 p.m.

Last Refresh Time: Tue Sep 18, 2012 2:47:37 p.m.

Execution ID: 1

User: SH

The Time & Wait Statistics group has the following label-value pairs:

Duration: bar and 2.8m

Database Time: bar and 2.8m

PL/SQL & Java: 0us

Wait Activity %: 100

The IO Statistics group has the following label-value pairs:

Buffer Gets: 0

IO Requests: bar and 1,480

IO Bytes: bar and 81MB

The Details group has the Activity subpage and the Metrics subpage. The Activity subpage is showing. The subpage has the CPU Cores option, which is selected. The page has a stacked area chart. The y-axis values are the average active sessions. The x-axis values are times of day in 20 second intervals from 2:45:30 p.m. to 2:47:30 p.m.

The legend to the right of the chart has the following items: Total Activity, CPU Cores, sql_id: 75g0d6c4dh7r8, sql_id: ctv199sqz0wdg, sql_id: 14gfqcy9qw856. The chart has a line representing the number of CPU cores at 2 on the y-axis and extending the length of the x-axis. The charts shows the amount and duration of activity of the operations.