Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

Wait Events and Parameters

The following wait events are present in the Oracle Database. The columns P1, P2, and P3 represent parameters for the wait event. Selected parameters and wait events are further described in the sections that follow.

Event Name P1 P2 P3
alter system set dispatcher waited
   
ARCH random i/o      
ARCH sequential i/o      
ARCH wait for archivelog lock      
ARCH wait on ATTACH      
ARCH wait on DETACH      
ARCH wait on SENDREQ      
async disk IO count intr timeout
block change tracking buffer space      
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      
buffer busy group# obj# block#
buffer busy waits file#
block#
class#
buffer deadlock dba
class*10+mode flag
buffer dirty disabled group#    
buffer freelistbusy group# obj# block#
buffer invalidation wait group# obj# block#
buffer latch latch addr chain#  
buffer pool resize buffer pool id current size new size
buffer read retry file#
block#
 
buffer rememberlist busy group# obj# block#
buffer resize      
buffer write wait group# obj# block#
buffer writeList full group# obj# block#
CGS skgxn join retry retry count    
CGS wait for IPC msg      
checkpoint completed      
contacting SCN server or SCN lock master      
control file heartbeat      
control file parallel write files blocks requests
control file sequential read file#
block#
blocks
control file single write file#
block#
blocks
conversion file read block#
blocks
 
cr request retry file# block#  
db file parallel read files blocks requests
db file parallel write files blocks requests
db file scattered read file#
block#
blocks
db file sequential read file#
block#
blocks
db file single write file#
block#
blocks
debugger command not used not used not used
DFS db file lock file#
not used not used
DFS lock handle type | mode id1
id2
direct path read file number first dba block cnt
direct path read temp file number first dba block cnt
direct path write file number first dba block cnt
direct path write temp file number first dba block cnt
dispatcher shutdown      
dispatcher timer sleep time not used not used
DLM generic wait event      
dupl. cluster key dba
not used not used
enqueue name | mode id1
id2
fib/fob latch      
file identify fib file name opcode
file open fib iov 0
free buffer waits file#
block#
set-id#
free global transaction table entry tries    
free process state object      
gcs domain validation cluinc rcvinc  
gcs for action      
gcs remote message waittime poll p3
gcs to be enabled      
ges cached resource cleanup waittime    
ges cancel      
ges cgs de-registration      
ges cgs registration      
ges drm deferred close      
ges enter server mode      
ges generic event      
ges global resource directory to be frozen      
ges global resource directory to be unfrozen      
ges inquiry response type|mode id1 id2
ges lmd and pmon to attach      
ges LMD suspend for testing event      
ges LMD to inherit communication channels      
ges LMD to shutdown      
ges lmd/lmses to freeze in rcfg - mrcvr      
ges lmd/lmses to freeze in rcfg - srcvr      
ges lmd/lmses to unfreeze in rcfg - mrcvr      
ges lmd/lmses to unfreeze in rcfg - srcvr      
ges LMON for send buffers to be empty      
ges LMON for send queues      
ges LMON to get to FTDONE      
ges LMON to join CGS group      
ges LMS suspend for testing event      
ges master to get established for SCN op      
ges performance test completion      
ges pmon to exit      
ges proc table latch - kjdrptref      
ges process allocation      
ges process with outstanding i/o pid    
ges reconfiguration to start      
ges remote message waittime loop p3
ges resource cleanout during enqueue open      
ges resource cleanout during enqueue open-cvt      
ges reusing os pid pid count  
ges server qs to be empty - kjbrrit      
ges1 LMON to wake up LMD      
ges1 LMON to wake up LMD - mrcvr      
ges2 LMON to wake up LMD - mrcvr      
ges2 LMON to wake up LMD - srcvr      
ges2 LMON to wake up lms - mrcvr 2      
global cache assume wait le
   
global cache bg acks count loops  
global cache busy file#
block#
id
global cache cancel wait le
   
global cache claim wait      
global cache cr cancel wait le
   
global cache cr disk request file#
block#
le
global cache cr request file#
block#
le
global cache domain validation      
global cache freelist wait      
global cache null to s file#
block#
le
global cache null to x file#
block#
le
global cache open s file#
block#
le
global cache open x file#
block#
le
global cache pending ast le
   
global cache pred cancel wait le
   
global cache recovery free wait      
global cache recovery quiesce wait le
   
global cache retry prepare file#
block#
 
global cache s to x file#
block#
le
i/o slave wait msg ptr    
imm op msg ptr    
inactive session session#
waited
 
inactive transaction branch branch# waited
 
index (re)build online cleanup object mode wait
index (re)build online merge object mode wait
index (re)build online start object mode wait
index block split rootdba level childdba
instance recovery undo segment#    
instance state change layer value waited
io done msg ptr    
IPC busy async request      
IPC send completion sync send count    
IPC wait for name service busy      
IPC waiting for OSD resources      
jobq slave wait      
KJC: Wait for msg sends to complete      
kjctcisnd: Queue/Send client message      
kjctssqmg: quick message send wait      
kksfbc child completion      
kksfbc research      
kkshgnc reloop      
kksscl hash split      
ksxr poll remote instances      
L1 validation seghdr l1bmb  
latch activity address number process#
latch free address number tries
LGWR random i/o      
LGWR sequential i/o      
LGWR wait for redo copy copy latch #    
LGWR wait on ATTACH      
LGWR wait on DETACH      
LGWR wait on LNS      
LGWR wait on SENDREQ      
library cache load lock object address lock address 100*mask+namespace
library cache lock handle address lock address 100*mode+namespace
library cache pin handle address pin address 100*mode+namespace
listen endpoint status end-point# status  
LNS wait on ATTACH      
LNS wait on DETACH      
LNS wait on LGWR      
LNS wait on SENDREQ      
local write wait file# block#  
lock deadlock retry      
lock escalate retry      
log buffer space      
log file parallel write files blocks requests
log file sequential read log# block#
blocks
log file single write log# block#
blocks
log file switch (archiving needed)      
log file switch (checkpoint incomplete)      
log file switch (clearing log file)      
log file switch completion      
log file sync buffer#    
log switch/archive thread#    
multiple dbwriter suspend/resume for file offline      
name-service call wait waittime    
null event      
parallel recovery coordinator waits for cleanup of slaves      
pending global transaction(s) scans    
pi renounce write complete file#
block#
 
pipe get handle address buffer length timeout
pipe put handle address record length timeout
PL/SQL lock timer duration    
pmon timer duration    
process shutdown type process# waited
process startup type process# waited
PX create server nservers sleeptime enqueue
PX Deq Credit: free buffer sleeptime/senderid passes qref
PX Deq Credit: need buffer sleeptime/senderid passes qref
PX Deq Credit: send blkd sleeptime/senderid passes qref
PX Deq: Execute Reply sleeptime/senderid passes  
PX Deq: Execution Msg sleeptime/senderid passes  
PX Deq: Index Merge Close sleeptime/senderid passes  
PX Deq: Index Merge Execute sleeptime/senderid passes  
PX Deq: Index Merge Reply sleeptime/senderid passes  
PX Deq: Join ACK sleeptime/senderid passes  
PX Deq: kdcph_mai kdcph_mai    
PX Deq: kdcphc_ack kdcphc_ack    
PX Deq: Msg Fragment sleeptime/senderid passes  
PX Deq: OLAP Update Close sleeptime/senderid passes  
PX Deq: OLAP Update Execute sleeptime/senderid passes  
PX Deq: OLAP Update Reply sleeptime/senderid passes  
PX Deq: Par Recov Change Vector sleeptime/senderid passes  
PX Deq: Par Recov Execute sleeptime/senderid passes  
PX Deq: Par Recov Reply sleeptime/senderid passes  
PX Deq: Parse Reply sleeptime/senderid passes  
PX Deq: reap credit      
PX Deq: Signal ACK sleeptime/senderid passes  
PX Deq: Table Q Close sleeptime/senderid passes  
PX Deq: Table Q Get Keys sleeptime/senderid passes  
PX Deq: Table Q Normal sleeptime/senderid passes  
PX Deq: Table Q qref sleeptime/senderid passes  
PX Deq: Table Q Sample sleeptime/senderid passes  
PX Deq: Test for msg sleeptime/senderid passes  
PX Deq: Txn Recovery Reply sleeptime/senderid passes  
PX Deq: Txn Recovery Start sleeptime/senderid passes  
PX Deque wait sleeptime/senderid passes  
PX Idle Wait sleeptime/senderid passes  
PX Nsq: PQ descriptor query      
PX Nsq: PQ load info query      
PX qref latch function sleeptime qref
PX Send Wait      
PX server shutdown nalive sleeptime loop
PX signal server serial error nbusy
PX slave connection      
PX slave release      
queue messages queue id process# wait time
rdbms ipc message timeout    
rdbms ipc message block      
rdbms ipc reply from_process timeout  
recovery read      
refresh controlfile command      
reliable message channel context channel handle broadcast message
Replication Dequeue sleeptime/senderid passes  
resmgr:wait in actses run      
resmgr:waiting for cschlat1      
resmgr:waiting for cschlat2      
resmgr:waiting for cschlat3      
resmgr:waiting for cschlat4      
resmgr:waiting in check      
resmgr:waiting in check2      
resmgr:waiting in end wait      
resmgr:waiting in end wait2      
resmgr:waiting in enter      
resmgr:waiting in enter2      
resmgr:waiting in run (queued)      
resmgr:waiting in shutdown      
resmgr:waiting in system stop      
retry contact SCN lock master      
RFS random i/o      
RFS sequential i/o      
row cache lock cache id mode
request
row cache read cache id address times
sbtbackup      
sbtclose      
sbtclose2      
sbtcommand      
sbtend      
sbterror      
sbtinfo      
sbtinfo2      
sbtinit      
sbtinit2      
sbtopen      
sbtpcbackup      
sbtpccancel      
sbtpccommit      
sbtpcend      
sbtpcquerybackup      
sbtpcqueryrestore      
sbtpcrestore      
sbtpcstart      
sbtpcstatus      
sbtpcvalidate      
sbtread      
sbtread2      
sbtremove      
sbtremove2      
sbtrestore      
sbtwrite      
sbtwrite2      
scginq AST call      
secondary event event # wait time  
select wait      
single-task message      
slave exit nalive sleeptime loop
slave shutdown wait      
slave TJ process wait      
smon timer sleep time failed  
sort segment request      
SQL*Net break/reset to client driver id
break?
not used
SQL*Net break/reset to dblink driver id
break?
not used
SQL*Net message from client driver id
#bytes not used
SQL*Net message from dblink driver id
#bytes not used
SQL*Net message to client driver id
#bytes not used
SQL*Net message to dblink driver id
#bytes not used
SQL*Net more data from client driver id
#bytes not used
SQL*Net more data from dblink driver id
#bytes not used
SQL*Net more data to client driver id
#bytes not used
SQL*Net more data to dblink driver id
#bytes not used
statement suspended, wait error to be cleared      
STREAMS apply coord waiting for slave message      
STREAMS apply slave waiting for coord message      
STREAMS capture process filter callback wait for ruleset      
STREAMS capture process waiting for archive log      
STREAMS fetch slave waiting for txns      
Streams: Wating for DDL to apply sleep time    
switch logfile command      
switch undo - offline      
timer in sksawat      
trace continue delay time    
trace unfreeze      
trace writer flush      
trace writer I/O      
transaction undo seg#|slot# wrap# count
txn to complete      
unbound tx      
undo segment extension segment#    
undo segment recovery segment# tx flags  
undo segment tx slot segment#    
virtual circuit status circuit# status  
wait for a paralle reco to abort      
wait for a undo record      
wait for activate message      
wait for another txn - rollback to savepoint      
wait for another txn - txn abort      
wait for another txn - undo rcv abort      
wait for assert messages to be sent      
Wait for Dictionary Build to lock all tables      
wait for EMON to spawn      
wait for FMON to come up      
wait for Logical Standby Apply shutdown      
wait for master scn waittime    
wait for membership change      
wait for membership synchronization      
wait for message ack      
wait for MTTR advisory state object      
wait for name service busy      
wait for possible quiesce finish      
wait for record update      
wait for rr lock release      
wait for scn from all nodes waittime    
wait for split-brain resolution      
wait for stopper event to be increased      
wait for sync ack cluinc pending_nd  
wait for tmc2 to complete      
wait for transaction      
wait for unread message on broadcast channel channel context channel handle  
wait for unread message on multiple broadcast channels channel context channel handle count  
wait for verification ack cluinc pending_insts  
wait for votes      
wait list latch activity address number process#
wait list latch free address number tries
waiting to get CAS latch      
waiting to get RM CAS latch      
wakeup event for builder      
wakeup event for preparer      
wakeup event for reader      
wakeup time manager      
write complete waits file# block#  
writes stopped by instance recovery or database suspension by thread# our thread#