События ожидания говорят о работе процессов в базе данных. Анализируя события ожиданий можно определить узкие места в работе базы, определить параметры требующие тюнинга.
batched allocate scn lock request
BFILE check if exists
BFILE check if open
BFILE closure
BFILE get length
BFILE get name object
BFILE get path object
BFILE internal seek
BFILE open
BFILE read
broadcast mesg queue transition
broadcast mesg recovery queue transition
buffer busy waits
buffer deadlock
buffer for checkpoint
buffer latch
buffer read retry
checkpoint completed
cleanup of aborted processes
control file parallel write
control file sequential read
control file single write
cursor: mutex S
cursor: mutex X
cursor: pin S
cursor: pin S wait on X
cursor: pin X
Data Guard: process clean up
Data Guard: process exit
Data Guard Broker: single instance
db file parallel read
db file parallel write
db file scattered read
db file sequential read
db file single write
DFS db file lock