Август 2004


Тема номера: «Сделано в России»


Oracle Server
Список событий ожидания

Источник: сайт компании «DBGroup Consulting»,
http://www.dbgroup.ru/stuff/oramanual/waits/

Событие ожиданияОписание
alter system set dispatchers9.2.0
batched allocate scn lock request9.2.0
BFILE check if exists9.2.0
BFILE check if open9.2.0
BFILE closure9.2.0
BFILE get length9.2.0
BFILE get name object9.2.0
BFILE get path object9.2.0
BFILE internal seek9.2.0
BFILE open9.2.0
BFILE read9.2.0
buffer busy waits9.2.0
buffer deadlock9.2.0
buffer for checkpoint9.2.0
buffer latch9.2.0
buffer read retry9.2.0
checkpoint completed9.2.0
checkpoint range buffer not saved9.2.0
control file parallel write9.2.0
control file sequential read9.2.0
control file single write9.2.0
conversion file read9.2.0
db file parallel read9.2.0
db file parallel write9.2.0
db file scattered read9.2.0
db file sequential read9.2.0
db file single write9.2.0
DFS db file lock9.2.0
DFS lock handle9.2.0
direct path read9.2.0
direct path write9.2.0
dispatcher shutdown9.2.0
dispatcher timer9.2.0
duplicate cluster key9.2.0
enqueue9.2.0
file identify9.2.0
file open9.2.0
free buffer waits9.2.0
free global transaction table entry9.2.0
free process state object9.2.0
global cache busy9.2.0
global cache lock cleanup9.2.0
global cache freelist wait9.2.0
global cache null to s9.2.0
global cache null to x9.2.0
global cache open s9.2.0
global cache open x9.2.0
global cache s to x9.2.0
inactive session9.2.0
inactive transaction branch9.2.0
index block split9.2.0
instance recovery9.2.0
instance state change9.2.0
io done9.2.0
kcl bg acks9.2.0
latch activity9.2.0
latch free9.2.0
library cache load lock9.2.0
library cache lock9.2.0
library cache pin9.2.0
lock manager wait for remote message9.2.0
log buffer space9.2.0
log file parallel write9.2.0
log file sequential read9.2.0
log file single write9.2.0
log file switch (archiving needed)9.2.0
log file switch (checkpoint incomplete)9.2.0
log file switch (clearing log file)9.2.0
log file switch completion9.2.0
log file sync9.2.0
log switch/archive9.2.0
on-going SCN fetch to complete9.2.0
parallel execution create server9.2.0
parallel execution dequeue wait9.2.0
parallel execution qref latch9.2.0
parallel execution server shutdown9.2.0
parallel execution signal server9.2.0
pending global transaction(s)9.2.0
pipe get9.2.0
pipe put9.2.0
PL/SQL lock timer9.2.0
pmon rdomain attach9.2.0
pmon timer9.2.0
process startup9.2.0
queue messages9.2.0
rdbms ipc message9.2.0
rdbms ipc message block9.2.0
rdbms ipc reply9.2.0
redo wait9.2.0
row cache lock9.2.0
scginq AST call9.2.0
single-task message9.2.0
smon timer9.2.0
SQL*Net break/reset to client9.2.0
SQL*Net break/reset to dblink9.2.0
SQL*Net message from client9.2.0
SQL*Net message from dblink9.2.0
SQL*Net message to client9.2.0
SQL*Net message to dblink9.2.0
SQL*Net more data from client9.2.0
SQL*Net more data from dblink9.2.0
SQL*Net more data to client9.2.0
SQL*Net more data to dblink9.2.0
switch logfile command9.2.0
timer in sksawat9.2.0
transaction9.2.0
unbound tx9.2.0
undo segment extension9.2.0
undo segment recovery9.2.0
undo segment tx slot9.2.0
virtual circuit status9.2.0
WMON goes to sleep9.2.0
write complete waits9.2.0
writes stopped by instance recovery or database suspension9.2.0

© 2003-2004 «DBGroup Consulting» 

E-mail this page