Resource Breakdown

Performance Analysis for Oracle

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:

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