Description of the illustration top_activity.gif

The Top Activity page is shown. The View Data list on the right side of the page shows Real Time: 15 Second Refresh.

The Active Sessions chart is shown. The y-axis records active sessions. The values start at 0 and go to 9. The x-axis are times of day in 10-minute intervals. The values start at 2:34 p.m. and go to 3:34 p.m. The legend next to the chart has the following wait classes: Other, Queueing, Network, Administrative, Configuration, Commit, Application, Concurrency, System I/O, User I/O, Scheduler, CPU + CPU Wait. A shaded box encompasses the time between 3:30 and 3:36.

The chart shows activity, in ascending order, in the CPU + CPU Wait, Scheduler, User I/O, Concurrency, and Other wait classes. The most active sessions are 2:44 to 2:48, 3:01 to 3:14 and 3:20 to 3:34. The highest spikes are in Other, with active sessions of 6.8 at 2:48, 7.5 at 3:01, and 7.9 at 3:30.

The Detail for Selected 5 Minute Interval section shows a Start Time of Dec 30, 2011, 3:26:00 PM. The Run ASH Report button is on the right side of the page.

The Top SQL section shows the Actions list value of Schedule SQL Tuning Advisor. The Go button is to the right of the list.

Below the Actions list are the Select All and Select None links.

The section has a table with the following columns: Select, Activity (%), SQL ID, and SQL Type. The Select column has a check box in each row. None of the boxes are selected. The rows in the Activity (%) column each has a bar that indicates the wait classes and a numerical value. The values in the SQL ID column are links.

The table has six rows. The values in the rows are the following:

Row 1: (check box), 17.4, ddthrb7j9a63f, SELECT.

Row 2: (check box), 15.06, axabnfyfp4r3p, SELECT.

Row 3: (check box), 11.99, f8ybh6brs1uq2, SELECT.

Row 4: (check box), 9.36, 94fzm3jx1c1yp, PL/SQL EXECUTE.

Row 5: (check box), 7.46, 95adfchfv58a5, UPDATE.

Row 6: (check box), 5.85, gff0kbjwvbsf8, SELECT.

The Top Sessions table is also displayed but is not relevant for this graph.

End of description.