Database Reference
In-Depth Information
Each of these tabs offers valuable information when inspecting a SQL statement for optimization opportunities,
baseline information, explain plan stability, and resource usage. By utilizing this small section of the Top Activity page,
the administrator can provide great insight quickly into any SQL statement captured.
Top Sessions Pane
Top Sessions encompasses the bottom-right pane of the Top Activity page by default. Although this section can be
changed to display top information regarding services, modules, actions, clients, files, objects, or PL/SQL
(see Figure
9-21
), session information is the main data that is found most useful by administrators.
Figure 9-21.
Top Sessions of the Top Activity page, along with the drop-down list of other Top options
In this pane, you can not only highlight wait events that are color coded to match the legend in the Top Activity
graph, but also access links to each of the SIDs and usernames. The program executing the session is also
displayed prominently to the right, helping to quickly distinguish the session.
As this page is distinguished by session information, clicking any SID opens the Session Details page.
Session Details Page
The Session Details page, unlike the SQL Details page, breaks down data at the session level. The tabs for this page are
General, Activity, Statistics, Open Cursors, Blocking Tree, Wait Event History, Parallel SQL, and SQL Monitoring.
Just as with the SQL Details page, the Session Details page defaults to the Activity tab, shown in Figure
9-22
.
