|
alter system set dispatcher
|
waited
|
|
|
|
ARCH random i/o
|
|
|
|
|
ARCH sequential i/o
|
|
|
|
|
ARCH wait on ATTACH
|
|
|
|
|
ARCH wait on DETACH
|
|
|
|
|
ARCH wait on SENDREQ
|
|
|
|
|
async disk IO
|
count
|
intr
|
timeout
|
|
background parameter adjustment
|
parameter number
|
|
|
|
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 global cache
|
file#
|
block#
|
id
|
|
buffer busy global CR
|
file#
|
block#
|
id
|
|
buffer busy waits
|
file#
|
block#
|
id
|
|
buffer deadlock
|
dba
|
class*10+mode
|
flag
|
|
buffer for checkpoint
|
buffer#
|
dba
|
state*10+mode
|
|
buffer latch
|
latch addr
|
chain#
|
not used
|
|
buffer read retry
|
file#
|
block#
|
not used
|
|
buffer resize
|
|
|
|
|
cache simulator heap
|
|
|
|
|
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 write
|
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
|
|
|
|
pipe get
|
handle address
|
buffer length
|
timeout
|
|
pipe put
|
handle address
|
record length
|
timeout
|
|
PL/SQL lock timer
|
duration
|
|
|
|
pmon timer
|
duration
|
|
|
|
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: 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#
|
|
