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
|
checkpoint completed
|
not used
|
not used
|
not used
|
checkpoint range buffer not saved
|
not used
|
not used
|
not used
|
Contacting SCN server or SCN lock master
|
|
|
|
control file parallel write
|
files
|
blocks
|
requests
|
control file sequential read
|
file#
|
block#
|
blocks
|
control file single write
|
file#
|
block#
|
blocks
|
conversion file read
|
file#
|
block#
|
blocks
|
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
|
file identify
|
fib
|
file name
|
opcode
|
file open
|
fib
|
iov
|
0
|
free buffer waits
|
file#
|
block#
|
set-id#
|
free global transaction table entry
|
tries
|
not used
|
not used
|
free process state object
|
not used
|
not used
|
not used
|
global cache bg acks
|
|
|
|
global cache cr request
|
|
|
|
global cache freelist wait
|
lenum
|
not used
|
not used
|
global cache lock busy
|
file#
|
block#
|
lenum
|
global cache lock cleanup
|
file#
|
block#
|
lenum
|
global cache lock null to s
|
file#
|
block#
|
lenum
|
global cache lock null to x
|
file#
|
block#
|
lenum
|
global cache lock open null
|
file#
|
block#
|
class
|
global cache lock open s
|
file#
|
block#
|
lenum
|
global cache lock open x
|
file#
|
block#
|
lenum
|
global cache lock s to x
|
file#
|
block#
|
lenum
|
global cache multiple locks
|
|
|
|
global cache pending ast
|
|
|
|
imm op
|
msg ptr
|
not used
|
not used
|
inactive session
|
session#
|
waited
|
not used
|
inactive transaction branch
|
branch#
|
waited
|
not used
|
index block split
|
rootdba
|
level
|
childdba
|
instance recovery
|
undo segment#
|
not used
|
not used
|
instance state change
|
layer
|
value
|
waited
|
io done
|
msg ptr
|
|
|
jobq slave wait
|
|
|
|
KJC Snd: Queue/Send client message
|
|
|
|
KJC: Wait for msg sends to complete
|
|
|
|
KJCTS client waiting for tickets
|
|
|
|
kksfbc child completion
|
|
|
|
kksfbc research
|
|
|
|
kkshgnc reloop
|
|
|
|
kksscl hash split
|
|
|
|
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
|
|
lmon waiting for lmd/lms to freeze in step 14
|
|
|
|
lmon waiting for lmd/lms to unfreeze in step 14
|
|
|
|
LNS wait on ATTACH
|
|
|
|
LNS wait on DETACH
|
|
|
|
LNS wait on LGWR
|
|
|
|
LNS wait on SENDREQ
|
|
|
|
local write wait
|
file#
|
block#
|
|
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
|
|
|
|
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 EMON to spawn
|
|
|
|
wait for Logical Standby Apply shutdown
|
|
|
|
wait for membership synchronization
|
|
|
|
wait for message ack
|
|
|
|
wait for name service busy
|
|
|
|
wait for possible quiesce finish
|
|
|
|
wait for record update
|
|
|
|
wait for rr lock release
|
|
|
|
wait for stopper event to be increased
|
|
|
|
wait for sync ack
|
cluinc
|
pending_nd
|
|
wait for tmc2 to complete
|
|
|
|
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
|
|
|
|
waiting for slave message
|
|
|
|
waiting to get 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#
|
|