Wait events talk about the running processes in the database. By analyzing wait events, you can identify bottlenecks in the database, determine the parameters that require tuning.


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

DFS lock handle

direct path read

direct path sync

direct path write

Disk file operations I/O

dispatcher shutdown