Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Oracle Wait Events, 3 of 5


Wait Events and Parameters

The following wait events are present in the Oracle database server. The columns P1, P2, and P3 represent parameters for the wait event. Selected parameters and wait events are further described in the sections that follow.

Event Name P1 P2 P3

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#


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback