Database Reference
In-Depth Information
Figure 9-10.
Top Activity graph for EM12c, demonstrating higher than normal I/O waits
The legend on the right consists of links for the wait events, shown for each color. Clicking any of these opens the
Active Sessions page for that wait event, as shown in Figure
9-11
. You can then lock in on a given wait event to gather
more details.
Figure 9-11.
Wait events highlighted for CPU + CPU Wait
By hovering over the wait event, the resource usage in the graph for that specific wait are highlighted. Upon
clicking the CPU + CPU Wait option, for example, you are connected to the page displaying the detail information on
all sessions experiencing waits for CPU + CPU Wait, as shown in Figure
9-12
.
Figure 9-12.
Displaying only wait information for SQL ID and sessions that are experiencing waits for CPU and
Waiting for CPU
The grayed area in the Top Activity graph, shown earlier in Figure
9-10
, is then detailed in the lower sections of
the Top Activity page, defaulting to Top SQL and Top Sessions (see Figure
9-13
). Note that each of the wait areas to the
left of each SQL ID in the left panel and each Session ID in the right panel are color coded in green, to show that they
are CPU wait events.
