Resource Breakdown
The Resource Breakdown pie chart and drill-down dialog pane listing display the relative Oracle wait event usage over the accompanying displayed activity timeline. In this manner, you get an overall period measurement of resource usage, abstracting from peak and null periods.
When you drill down into the resource breakdown pie chart, the focus and display are dependent on your access path.
Clicking on Wait Events... displays the dialog in accordance with the default Resource selection.
Clicking on a specific slice of the total pie chart (or double-clicking on a resource event category within the entire pane-listed Workload) opens the dialog box focused on the chosen wait event category.
In either case, specific or other resources can be chosen through the Resource drop-down listing from within the Wait Events... dialog. The two data columns are defined as follows:
Percent of Total - The portion of the entire wait event activity (as a percentage of the entire activity)
Duration - Depending on the = 4) BSPSPopupOnMouseOver(event)" CLASS=BSSCPopup id=A1>totaling method in effect, this value represents the time (in seconds) consumed by this event per time unit specified.
Several Oracle wait events facilitate further breakdown
to their internal composing parameters (those with the icon () at their left). For example, I/O events can be broken into
the actual files on which the I/O operation has been performed.
For the key selected events, the text pane in the lower half of the window displays the actual Oracle wait event parameters of the selected resource. The parameters appear in accordance with the click-on-line focus for those events with an icon to the left, as in the preceding display.
Resource |
Event Name |
Parameter Breakdown |
I/O |
direct path read temp |
File Name |
direct path write temp |
||
write complete waits |
||
db file sequential read |
||
db file scattered read |
||
db file single write |
||
direct path read |
||
direct path write |
||
direct path read (lob) |
||
direct path write (lob) |
||
Buffer |
buffer busy waits |
File Name |
free buffer waits |
||
local write wait |
||
buffer busy global cache |
||
buffer busy global CR |
||
Lock |
global cache or disk request |
File Name |
Latch |
latch activity |
Latch Name |
latch free |
||
buffer latch |
||
wait list latch activity |
||
wait list latch free |
||
Other |
buffer read retry |
File Name |
DFS db file lock |
||
global cache open s |
||
global cache open x |
||
global cache null to s |
||
global cache null to x |
||
global cache s to x |
||
global cache cr request |
||
global cache busy |
||
global cache retry prepare |
||
global cache lock busy |
||
global cache lock cleanup |
||
global cache lock null to s |
||
global cache lock null to x |
||
global cache lock open s |
||
global cache lock open ss |
||
global cache lock open x |
||
global cache lock s to x |
||
global cache multiple locks |
||
global cache retry request |
||
global cache cr disk request |
||
global cache current request |
||
global cache cr multi block |
||
gc current multi block |
||
gc buffer busy |
||
gc current request |
||
gc cr request |
||
gc cr disk request |
||
gc cr multi block request |
||
gc block recovery request |