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