|
alter system set mts_dispatcher |
waited |
not used |
not used |
|
batched allocate scn lock request |
not used |
not used |
not used |
|
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 being modified waits |
|
|
|
|
buffer busy due to global cache |
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 clients wait for LMON to join GMS group |
|
|
|
|
io done |
msg ptr |
not used |
not used |
|
kcl bg acks |
count |
loops |
not used |
|
kdi: Done Message Dequeue-Coord |
|
|
|
|
ktpr: Done Message Dequeue-Coord |
|
|
|
|
latch activity |
address |
number |
process# |
|
latch free |
address |
number |
tries |
|
library cache load lock |
object address |
lock address |
10*mask+namespace |
|
library cache lock |
handle address |
lock address |
10*mode+namespace |
|
library cache pin |
handle address |
pin address |
10*mode+namespace |
|
LMON wait for LMD to inherit communication channels |
|
|
|
|
local write wait |
|
|
|
|
lock manager wait for dlmd to shutdown |
|
|
|
|
lock manager wait for remote message |
waittime |
not used |
not used |
|
log buffer space |
not used |
not used |
not used |
|
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) |
not used |
not used |
not used |
|
log file switch (checkpoint incomplete |
not used |
not used |
not used |
|
log file switch (clearing log file) |
not used |
not used |
not used |
|
log file switch completion |
not used |
not used |
not used |
|
log file sync |
buffer# |
not used |
not used |
|
log switch/archive |
thread# |
not used |
not used |
|
name-service call wait |
|
|
|
|
Null event |
|
|
|
|
on-going SCN fetch to complete |
not used |
not used |
not used |
|
PAR RECOV: Dequeue msg-Slave |
|
|
|
|
PAR RECOV: Wait for reply-Query Coord |
|
|
|
|
parallel execution create server |
nservers |
sleeptime |
enqueue |
|
parallel execution dequeue wait |
reason |
sleeptime/senderid |
passes |
|
Parallel Execution Idle Wait-Slaves wait event |
|
|
|
|
parallel execution qref latch |
function |
sleeptime |
qref |
|
parallel execution server shutdown |
nalive |
sleeptime |
loop |
|
parallel execution signal server |
serial |
error |
nbusy |
|
pending global transaction(s) |
scans |
not used |
not used |
|
pipe get |
handle address |
buffer length |
timeout |
|
pipe put |
handle address |
record length |
timeout |
|
PL/SQL lock timer |
duration |
not used |
not used |
|
pmon rdomain attach |
|
|
|
|
pmon timer |
duration |
not used |
not used |
|
process startup |
type |
process# |
waited |
|
queue messages |
queue id |
process# |
wait time |
|
rdbms ipc message |
timeout |
not used |
not used |
|
rdbms ipc message block |
not used |
not used |
not used |
|
rdbms ipc reply |
from_process |
timeout |
not used |
|
redo wait |
not used |
not used |
not used |
|
refresh controlfile command |
|
|
|
|
reliable message |
|
|
|
|
Replication Dequeue |
|
|
|
|
retry contact SCN lock master |
|
|
|
|
row cache lock |
cache id |
mode |
request |
|
scginq AST call |
not used |
not used |
not used |
|
secondary event |
|
|
|
|
single-task message |
not used |
not used |
not used |
|
slave exit |
nalive |
sleeptime |
loop |
|
slave wait |
|
|
|
|
smon timer |
sleep time |
failed |
not used |
|
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 |
|
switch logfile command |
not used |
not used |
not used |
|
Test if message present |
|
|
|
|
timer in sksawat |
not used |
not used |
not used |
|
trace continue |
|
|
|
|
trace unfreeze |
|
|
|
|
trace writer flush |
|
|
|
|
trace writer I/O |
|
|
|
|
transaction |
undo seg#| slot# |
wrap# |
count |
|
unbound tx |
not used |
not used |
not used |
|
undo segment extension |
segment# |
not used |
not used |
|
undo segment recovery |
segment# |
tx flags |
not used |
|
undo segment tx slot |
segment# |
not used |
not used |
|
virtual circuit status |
circuit# |
status |
not used |
|
Wait for a parallel reco to abort |
|
|
|
|
Wait for a undo record |
|
|
|
|
wait for checking DLM domain |
|
|
|
|
Wait for credit-free buffer |
|
|
|
|
Wait for credit-need buffer to send |
|
|
|
|
Wait for credit-send blocked |
|
|
|
|
wait for DLM |
|
|
|
|
wait for DLM latch |
latchtype |
gets |
immediate |
|
wait for DLM process allocation |
|
|
|
|
wait for DLM reconfiguration to complete |
|
|
|
|
wait for gms de-registration |
|
|
|
|
wait for gms registration |
|
|
|
|
wait for influx DLM latch |
latchtype |
latchaddr |
not used |
|
wait for lmd and pmon to attach DLM |
|
|
|
|
wait for lock db to become frozen |
|
|
|
|
wait for lock db to unfreeze |
|
|
|
|
wait for ownership of group-owned lock |
|
|
|
|
wait for pmon to exit |
|
|
|
|
wait for reconfiguration to start |
|
|
|
|
wait for recovery domain attach |
|
|
|
|
wait for recovery domain latch in kjpr |
|
|
|
|
wait for recovery validate to complete |
|
|
|
|
wait for register recovery to complete |
|
|
|
|
wait for send buffers to send DLM message |
|
|
|
|
Wait for slaves to ACK-Query Coord |
|
|
|
|
Wait for slaves to join-Query Coord |
|
|
|
|
Wait for stopper event to be increased |
|
|
|
|
wait for tickets to send DLM message |
|
|
|
|
wait to run in thread run |
|
|
|
|
waiting in scheduler enter |
|
|
|
|
waiting in scheduler enter2 |
|
|
|
|
waiting in scheduler shutdown |
|
|
|
|
waiting in scheduler system stop |
|
|
|
|
waiting in thread check |
|
|
|
|
waiting in thread check2 |
|
|
|
|
waiting in thread end wait |
|
|
|
|
waiting in thread run (queued) |
|
|
|
|
WMON goes to sleep |
not used |
not used |
not used |
|
write complete waits |
file# |
block# |
id |
|
writes stopped by instance recovery or database suspension |
by thread # |
our thread# |
not used |
