top of page
Волнистый абстрактный фон


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

dispatcher timer

duplicate cluster key

enq: OW – initialization

enq: OW – termination


flashback buf free by RVWR

flashback logfile sync

free buffer waits

free global transaction table entry

free process state object

gc recovery quiesce

GCS lock open S

GCS lock open X

gcs remastering wait for drop pkey

global cache busy

global cache lock cleanup

global cache freelist

inactive session

inactive transaction branch