Топ-100
top of page
Волнистый абстрактный фон
CerebroSQL

ORACLE SESSION EVENT

События ожидания говорят о работе процессов в базе данных. Анализируя события ожиданий можно определить узкие места в работе базы, определить параметры требующие тюнинга.

oracle-logo

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

broadcast mesg queue transition

broadcast mesg recovery queue transition

buffer busy waits

buffer deadlock

buffer for checkpoint

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