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# |
|