[10g]Oracle 10g Wait Event Names

Name	Wait Class	P1	P2	P3
alter rbs offline	Administrative
alter system set dispatcher	Administrative	waited
AQ Deallocate Wait	Configuration
AQ Proxy Cleanup Wait	Idle
ARCH random i/o	System I/O
ARCH sequential i/o	System I/O
ARCH wait for archivelog lock	Other
ARCH wait for flow-control	Network
ARCH wait for net re-connect	Network
ARCH wait for netserver detach	Network
ARCH wait for netserver init 1	Network
ARCH wait for netserver init 2	Network
ARCH wait for netserver start	Network
ARCH wait for pending I/Os	System I/O
ARCH wait for process death 1	Other
ARCH wait for process death 2	Other
ARCH wait for process death 3	Other
ARCH wait for process death 4	Other
ARCH wait for process death 5	Other
ARCH wait for process start 1	Other
ARCH wait for process start 2	Other
ARCH wait for process start 3	Other
ARCH wait for process start 4	Other
ARCH wait on ATTACH	Network
ARCH wait on c/f tx acquire 1	Other
ARCH wait on c/f tx acquire 2	Other
ARCH wait on DETACH	Network
ARCH wait on SENDREQ	Network
ASM background running	Other
ASM background starting	Other
ASM background timer	Idle
ASM db client exists	Other
ASM mount : wait for heartbeat	Administrative
ASM PST query : wait for [PM][grp][0] grant	Cluster
Backup: sbtbackup	Administrative
Backup: sbtclose	Administrative
Backup: sbtclose2	Administrative
Backup: sbtcommand	Administrative
Backup: sbtend	Administrative
Backup: sbterror	Administrative
Backup: sbtinfo	Administrative
Backup: sbtinfo2	Administrative
Backup: sbtinit	Administrative
Backup: sbtinit2	Administrative
Backup: sbtopen	Administrative
Backup: sbtpcbackup	Administrative
Backup: sbtpccancel	Administrative
Backup: sbtpccommit	Administrative
Backup: sbtpcend	Administrative
Backup: sbtpcquerybackup	Administrative
Backup: sbtpcqueryrestore	Administrative
Backup: sbtpcrestore	Administrative
Backup: sbtpcstart	Administrative
Backup: sbtpcstatus	Administrative
Backup: sbtpcvalidate	Administrative
Backup: sbtread	Administrative
Backup: sbtread2	Administrative
Backup: sbtremove	Administrative
Backup: sbtremove2	Administrative
Backup: sbtrestore	Administrative
Backup: sbtwrite	Administrative
Backup: sbtwrite2	Administrative
BFILE check if exists	Other
BFILE check if open	Other
BFILE closure	Other
BFILE get length	Other
BFILE get name object	Other
BFILE get path object	Other
BFILE internal seek	Other
BFILE open	Other
BFILE read	User I/O
block change tracking buffer space	Other
buffer busy	Other	group#	obj#	block#
buffer busy waits	Concurrency	file#	block#	class#
buffer deadlock	Other	dba	class*10+mode	flag
buffer dirty disabled	Other	group#
buffer exterminate	Other	file#	block#	buf_ptr
buffer freelistbusy	Other	group#	obj#	block#
buffer invalidation wait	Other	group#	obj#	block#
buffer latch	Other	latch addr	chain#
buffer pool resize	Administrative	buffer pool id	current size	new size
buffer read retry	User I/O	file#	block#
buffer rememberlist busy	Other	group#	obj#	block#
buffer resize	Other
buffer write wait	Other	group#	obj#	block#
buffer writeList full	Other	group#	obj#	block#
CGS skgxn join retry	Other	retry count
CGS wait for IPC msg	Other
change tracking file parallel write	Other	blocks	requests
change tracking file synchronous read	Other	block#	blocks
change tracking file synchronous write	Other	block#	blocks
check CPU wait times	Other
checkpoint advanced	Other	group#
checkpoint completed	Configuration
class slave wait	Other	slave id
Cluster stablization wait	Other
Cluster Suspension wait	Other
contacting SCN server or SCN lock master	Cluster
control file heartbeat	Other
control file parallel write	System I/O	files	block#	requests
control file sequential read	System I/O	file#	block#	blocks
control file single write	System I/O	file#	block#	blocks
cr request retry	Other	file#	block#
Data Guard broker: wait upon ORA-12850 error	Other	waiting for retrying the query to mask ORA-12850 error
db file parallel read	User I/O	files	blocks	requests
db file parallel write	System I/O	requests	interrupt	timeout
db file scattered read	User I/O	file#	block#	blocks
db file sequential read	User I/O	file#	block#	blocks
db file single write	User I/O	file#	block#	blocks
DBFG waiting for reply	Other
DBMS_LDAP: LDAP operation	Other
debugger command	Other
dedicated server timer	Network	wait event
DFS db file lock	Other	file#
DFS lock handle	Other	type|mode	id1	id2
DIAG dummy wait	Other
direct path read	User I/O	file number	first dba	block cnt
direct path read temp	User I/O	file number	first dba	block cnt
direct path write	User I/O	file number	first dba	block cnt
direct path write temp	User I/O	file number	first dba	block cnt
dispatcher listen timer	Network	sleep time
dispatcher shutdown	Other	waited
dispatcher timer	Idle	sleep time
DLM lock cancel	Other	le
DLM lock cvt S	Other	group	obj#	block#
DLM lock cvt X	Other	group	obj#	block#
DLM lock esc	Other	group	obj#	block#
DLM lock esc X	Other	group	obj#	block#
DLM lock open	Other	group	obj#	block#
DLM lock open S	Other	group	obj#	block#
DLM lock open X	Other	group	obj#	block#
DLM recovery lock convert	Other	group	obj#	block#
DLM recovery lock open	Other	group	obj#	block#
dma prepare busy	Other	group	obj#	block#
dupl. cluster key	Other	dba
enq: AD - allocate AU	Other	name|mode	group and disk number	AU number
enq: AD - deallocate AU	Other	name|mode	group and disk number	AU number
enq: AF - task serialization	Other	name|mode	task id	0
enq: AG - contention	Other	name|mode	workspace #	generation
enq: AO - contention	Other	name|mode	workspace #	object #
enq: AS - contention	Other	name|mode	0	0
enq: AT - contention	Other	name|mode	0	0
enq: AW - AW generation lock	Other	name|mode	operation	workspace #
enq: AW - AW state lock	Other	name|mode	operation	workspace #
enq: AW - AW$ table lock	Other	name|mode	operation	workspace #
enq: AW - user access for AW	Other	name|mode	operation	workspace #
enq: BR - file shrink	Other	name|mode	operation	file #
enq: BR - proxy-copy	Other	name|mode	operation	file #
enq: CF - contention	Other	name|mode	0	operation
enq: CI - contention	Other	name|mode	opcode	type
enq: CL - compare labels	Other	name|mode	object #	0
enq: CL - drop label	Other	name|mode	object #	0
enq: CM - gate	Other	name|mode	disk group #	type
enq: CM - instance	Other	name|mode	disk group #	type
enq: CT - change stream ownership	Other	name|mode	operation	operation parm
enq: CT - CTWR process start/stop	Other	name|mode	operation	operation parm
enq: CT - global space management	Other	name|mode	operation	operation parm
enq: CT - local space management	Other	name|mode	operation	operation parm
enq: CT - reading	Other	name|mode	operation	operation parm
enq: CT - state	Other	name|mode	operation	operation parm
enq: CT - state change gate 1	Other	name|mode	operation	operation parm
enq: CT - state change gate 2	Other	name|mode	operation	operation parm
enq: CU - contention	Other	name|mode	handle	handle
enq: DB - contention	Administrative	name|mode	EnqMode	0
enq: DD - contention	Other	name|mode	disk group	type
enq: DF - contention	Other	name|mode	0	file #
enq: DG - contention	Other	name|mode	disk group	type
enq: DL - contention	Other	name|mode	object #	0
enq: DM - contention	Other	name|mode	type	type
enq: DN - contention	Other	name|mode	0	0
enq: DP - contention	Other	name|mode	0	0
enq: DR - contention	Other	name|mode	0	0
enq: DS - contention	Other	name|mode	0	0
enq: DT - contention	Other	name|mode	0	0
enq: DV - contention	Other	name|mode	object #	0
enq: DX - contention	Other	name|mode	transaction entry #	0
enq: FA - access file	Other	name|mode	disk group number	file number
enq: FB - contention	Other	name|mode	tablespace #	dba
enq: FC - open an ACD thread	Other	name|mode	disk group	thread
enq: FC - recover an ACD thread	Other	name|mode	disk group	thread
enq: FD - Flashback coordinator	Other	name|mode	Internal	Internal
enq: FD - Flashback on/off	Other	name|mode	Internal	Internal
enq: FD - Marker generation	Other	name|mode	Internal	Internal
enq: FD - Tablespace flashback on/off	Other	name|mode	Internal	Internal
enq: FG - FG redo generation enq race	Other	name|mode	disk group	type
enq: FG - LGWR redo generation enq race	Other	name|mode	disk group	type
enq: FG - serialize ACD relocate	Other	name|mode	disk group	type
enq: FL - Flashback database log	Other	name|mode	Log #	zero
enq: FL - Flashback db command	Other	name|mode	Log #	zero
enq: FM - contention	Other	name|mode	0	0
enq: FR - contention	Other	name|mode	disk group	unused
enq: FS - contention	Other	name|mode	0	type
enq: FT - allow LGWR writes	Other	name|mode	disk group	thread
enq: FT - disable LGWR writes	Other	name|mode	disk group	thread
enq: FU - contention	Other	name|mode	0	0
enq: HD - contention	Other	name|mode	disk group	0
enq: HP - contention	Other	name|mode	tablespace #	dba
enq: HQ - contention	Other	name|mode	object #	hash value
enq: HV - contention	Other	name|mode	object #	0
enq: HW - contention	Configuration	name|mode	table space #	block
enq: IA - contention	Other	name|mode	0	0
enq: ID - contention	Other	name|mode	0	0
enq: IL - contention	Other	name|mode	object #	0
enq: IM - contention for blr	Other	name|mode	pool #	0
enq: IR - contention	Other	name|mode	0	0/1
enq: IR - contention2	Other	name|mode	0	0/1
enq: IS - contention	Other	name|mode	0	type
enq: IT - contention	Other	name|mode	object #	0
enq: JD - contention	Other	name|mode	0	0
enq: JI - contention	Other	name|mode	view object #	0
enq: JQ - contention	Other	name|mode	0	0
enq: JS - contention	Other	name|mode	service ID	queue type
enq: JS - coord post lock	Other	name|mode	service ID	queue type
enq: JS - coord rcv lock	Other	name|mode	service ID	queue type
enq: JS - global wdw lock	Other	name|mode	service ID	queue type
enq: JS - job chain evaluate lock	Other	name|mode	service ID	queue type
enq: JS - job recov lock	Other	name|mode	service ID	queue type
enq: JS - job run lock - synchronize	Other	name|mode	service ID	queue type
enq: JS - q mem clnup lck	Other	name|mode	service ID	queue type
enq: JS - queue lock	Other	name|mode	service ID	queue type
enq: JS - running job cnt lock	Other	name|mode	service ID	queue type
enq: JS - running job cnt lock2	Other	name|mode	service ID	queue type
enq: JS - running job cnt lock3	Other	name|mode	service ID	queue type
enq: JS - slave enq get lock1	Other	name|mode	service ID	queue type
enq: JS - slave enq get lock2	Other	name|mode	service ID	queue type
enq: KK - context	Other	name|mode	0	redo thread
enq: KM - contention	Other	name|mode	type	type
enq: KP - contention	Other	name|mode	0	0
enq: KT - contention	Other	name|mode	plan #	0
enq: MD - contention	Other	name|mode	master object #	0
enq: MH - contention	Other	name|mode	0	0
enq: ML - contention	Other	name|mode	0	0
enq: MN - contention	Other	name|mode	session ID	0
enq: MR - contention	Other	name|mode	0 or file #	type
enq: MS - contention	Other	name|mode	master object #	0
enq: MW - contention	Other	name|mode	Schedule Id	0
enq: OC - contention	Other	name|mode	1	2
enq: OL - contention	Other	name|mode	hash value	0
enq: OQ - xsoq*histrecb	Other	name|mode	resource id	0
enq: OQ - xsoqhiAlloc	Other	name|mode	resource id	0
enq: OQ - xsoqhiClose	Other	name|mode	resource id	0
enq: OQ - xsoqhiFlush	Other	name|mode	resource id	0
enq: OQ - xsoqhistrecb	Other	name|mode	resource id	0
enq: PD - contention	Other	name|mode	property name	key hash
enq: PE - contention	Other	name|mode	parno	0
enq: PF - contention	Other	name|mode	0	0
enq: PG - contention	Other	name|mode	0	0
enq: PH - contention	Other	name|mode	0	0
enq: PI - contention	Other	name|mode	operation	serial #
enq: PL - contention	Other	name|mode	0	0
enq: PR - contention	Other	name|mode	0	0
enq: PS - contention	Other	name|mode	instance	slave ID
enq: PT - contention	Other	name|mode	disk group #	type
enq: PV - syncshut	Other	name|mode	0	0
enq: PV - syncstart	Other	name|mode	0	0
enq: PW - flush prewarm buffers	Application	name|mode	0	0
enq: PW - perwarm status in dbw0	Other	name|mode	0	0
enq: RB - contention	Other	name|mode	disk group	0
enq: RF - atomicity	Other	name|mode	lock operation	lock value
enq: RF - new AI	Other	name|mode	lock operation	lock value
enq: RF - synch: per-SGA Broker metadata	Other	name|mode	lock operation	lock value
enq: RF - synchronization: aifo master	Other	name|mode	lock operation	lock value
enq: RF - synchronization: chief	Other	name|mode	lock operation	lock value
enq: RF - synchronization: critical ai	Other	name|mode	lock operation	lock value
enq: RF - synchronization: HC master	Other	name|mode	lock operation	lock value
enq: RN - contention	Other	name|mode	thread number	log number
enq: RO - contention	Application	name|mode	1	0
enq: RO - fast object reuse	Application	name|mode	1	0
enq: RP - contention	Other	name|mode	file #	1 or block
enq: RS - file delete	Other	name|mode	record type	record id
enq: RS - persist alert level	Other	name|mode	record type	record id
enq: RS - prevent aging list update	Other	name|mode	record type	record id
enq: RS - prevent file delete	Other	name|mode	record type	record id
enq: RS - read alert level	Other	name|mode	record type	record id
enq: RS - record reuse	Other	name|mode	record type	record id
enq: RS - write alert level	Other	name|mode	record type	record id
enq: RT - contention	Other	name|mode	redo thread	type
enq: SB - contention	Other	name|mode	0	0
enq: SF - contention	Other	name|mode	0	0
enq: SH - contention	Other	name|mode	0	0
enq: SI - contention	Other	name|mode	object #	0
enq: SK - contention	Other	name|mode	tablespace #	dba
enq: SQ - contention	Configuration	name|mode	object #	0
enq: SR - contention	Other	name|mode	operation	sequence # / apply #
enq: SS - contention	Other	name|mode	tablespace #	dba
enq: ST - contention	Configuration	name|mode	0	0
enq: SU - contention	Other	name|mode	table space #	0
enq: SW - contention	Other	name|mode	0	0
enq: TA - contention	Other	name|mode	operation	undo segment # / other
enq: TB - SQL Tuning Base Cache Load	Other	name|mode	1	2
enq: TB - SQL Tuning Base Cache Update	Other	name|mode	1	2
enq: TC - contention	Other	name|mode	checkpoint ID	0
enq: TC - contention2	Other	name|mode	checkpoint ID	0
enq: TD - KTF dump entries	Other	name|mode	0	0
enq: TE - KTF broadcast	Other	name|mode	0	0
enq: TF - contention	Other	name|mode	tablespace #	relative file #
enq: TL - contention	Other	name|mode	0	0
enq: TM - contention	Application	name|mode	object #	table/partition
enq: TO - contention	Other	name|mode	object #	1
enq: TQ - DDL contention	Other	name|mode	QT_OBJ#	0
enq: TQ - INI contention	Other	name|mode	QT_OBJ#	0
enq: TQ - TM contention	Other	name|mode	QT_OBJ#	0
enq: TS - contention	Other	name|mode	tablespace ID	dba
enq: TT - contention	Other	name|mode	tablespace ID	operation
enq: TW - contention	Administrative	name|mode	0	operation
enq: TX - allocate ITL entry	Configuration	name|mode	usn<<16 | slot	sequence
enq: TX - contention	Other	name|mode	usn<<16 | slot	sequence
enq: TX - index contention	Concurrency	name|mode	usn<<16 | slot	sequence
enq: TX - row lock contention	Application	name|mode	usn<<16 | slot	sequence
enq: UL - contention	Application	name|mode	id	0
enq: US - contention	Other	name|mode	undo segment #	0
enq: WA - contention	Other	name|mode	0	0
enq: WF - contention	Other	name|mode	0	0
enq: WL - contention	Other	name|mode	log # / thread id #	sequence #
enq: WP - contention	Other	name|mode	0	0
enq: XH - contention	Other	name|mode	0	0
enq: XR - database force logging	Other	name|mode	operation	0
enq: XR - quiesce database	Other	name|mode	operation	0
enq: XY - contention	Other	name|mode	id1	id2
extent map load/unlock	Other	group	file	extent
flashback buf free by RVWR	Other
flashback free VI log	Other
flashback log switch	Other
Flow Control Event	Other
foreground creation: start	Other
foreground creation: wait	Other
free buffer waits	Configuration	file#	block#	set-id#
free global transaction table entry	Other	tries
free process state object	Other
gc assume	Cluster	le
gc block recovery request	Cluster	file#	block#	class#
gc buffer busy	Cluster	file#	block#	id#
gc claim	Cluster
gc cr block 2-way	Cluster
gc cr block 3-way	Cluster
gc cr block busy	Cluster
gc cr block congested	Cluster
gc cr block unknown	Cluster
gc cr cancel	Cluster	le
gc cr disk read	Cluster
gc cr disk request	Cluster	file#	block#	class#
gc cr failure	Cluster
gc cr grant 2-way	Cluster
gc cr grant busy	Cluster
gc cr grant congested	Cluster
gc cr grant unknown	Cluster
gc cr multi block request	Cluster	file#	block#	class#
gc cr request	Cluster	file#	block#	class#
gc current block 2-way	Cluster
gc current block 3-way	Cluster
gc current block busy	Cluster
gc current block congested	Cluster
gc current block unknown	Cluster
gc current cancel	Cluster	le
gc current grant 2-way	Cluster
gc current grant busy	Cluster
gc current grant congested	Cluster
gc current grant unknown	Cluster
gc current multi block request	Cluster	file#	block#	id#
gc current request	Cluster	file#	block#	id#
gc current retry	Cluster
gc current split	Cluster
gc domain validation	Cluster
gc freelist	Cluster
gc prepare	Cluster
gc quiesce wait	Cluster
gc recovery free	Cluster
gc recovery quiesce	Cluster
gc remaster	Cluster
gcs ddet enter server mode	Other
gcs domain validation	Other	cluinc	rcvinc
gcs drm freeze begin	Other
gcs drm freeze in enter server mode	Other
gcs enter server mode	Other
gcs log flush sync	Other	waittime	poll	event
gcs remastering wait for read latch	Other
gcs remastering wait for write latch	Other
gcs remote message	Idle	waittime	poll	event
gcs resource directory to be unfrozen	Other
gcs to be enabled	Other
ges cached resource cleanup	Other	waittime
ges cancel	Other
ges cgs registration	Other
ges enter server mode	Other
ges generic event	Other
ges global resource directory to be frozen	Other
ges inquiry response	Other	type|mode	id1	id2
ges lmd and pmon to attach	Other
ges LMD suspend for testing event	Other
ges LMD to inherit communication channels	Other
ges LMD to shutdown	Other
ges lmd/lmses to freeze in rcfg - mrcvr	Other
ges lmd/lmses to unfreeze in rcfg - mrcvr	Other
ges LMON for send queues	Other
ges LMON to get to FTDONE	Other
ges LMON to join CGS group	Other
ges master to get established for SCN op	Other
ges performance test completion	Other
ges pmon to exit	Other
ges process with outstanding i/o	Other	pid
ges reconfiguration to start	Idle
ges remote message	Idle	waittime	loop	p3
ges resource cleanout during enqueue open	Other
ges resource cleanout during enqueue open-cvt	Other
ges resource directory to be unfrozen	Other
ges reusing os pid	Other	pid	count
ges user error	Other	error
ges wait for lmon to be ready	Other
ges1 LMON to wake up LMD - mrcvr	Other
ges2 LMON to wake up LMD - mrcvr	Other
ges2 LMON to wake up lms - mrcvr 2	Other
ges2 LMON to wake up lms - mrcvr 3	Other
ges2 proc latch in rm latch get 1	Other
ges2 proc latch in rm latch get 2	Other
global cache busy	Other	group	file#	block#
global enqueue expand wait	Other
GV$: slave acquisition retry wait time	Other
HS message to agent	Idle
i/o slave wait	Other	msg ptr
imm op	Other	msg ptr
inactive session	Other	session#	waited
inactive transaction branch	Other	branch#	waited
index (re)build online cleanup	Administrative	object	mode	wait
index (re)build online merge	Administrative	object	mode	wait
index (re)build online start	Administrative	object	mode	wait
index block split	Other	rootdba	level	childdba
instance state change	Other	layer	value	waited
io done	System I/O	msg ptr
IPC busy async request	Other
IPC send completion sync	Other	send count
IPC wait for name service busy	Other
IPC waiting for OSD resources	Other
job scheduler coordinator slave wait	Other
jobq slave wait	Idle
JS coord start wait	Other
JS external job	Idle
JS kgl get object wait	Other
JS kill job wait	Other
kcbzps	Other
kcrrrcp	Other
kdic_do_merge	Other
kfcl: instance recovery	Other	group	obj#	block#
kfk: async disk IO	System I/O	count	intr	timeout
kgltwait	Other
kjbdomalc allocate recovery domain - retry	Other
kjbdrmcvtq lmon drm quiesce: ping completion	Other
kjbopen wait for recovery domain attach	Other
KJC: Wait for msg sends to complete	Other	msg	dest|rcvr	mtype
kjctcisnd: Queue/Send client message	Other
kjctssqmg: quick message send wait	Other
kjudomatt wait for recovery domain attach	Other
kjudomdet wait for recovery domain detach	Other
kjxgrtest	Other
kkdlgon	Other
kkdlhpon	Other
kkdlsipon	Other
kksfbc child completion	Other
kksfbc research	Other
kkshgnc reloop	Other
kksscl hash split	Other
knlqdeq	Other
knlWaitForStartup	Other
knpc_acwm_AwaitChangedWaterMark	Other
knpc_anq_AwaitNonemptyQueue	Other
knpsmai	Other
ksbcic	Other
ksbsrv	Other
ksdxexeother	Other
ksdxexeotherwait	Other
ksfd: async disk IO	System I/O	count	intr	timeout
ksfd: fib/fob latch	Other
ksim generic wait event	Other	where	wait_count
ksqded	Other
ksv slave avail wait	Other
ksxr poll remote instances	Other
ktfbtgex	Other	tsn
ktm: instance recovery	Other	undo segment#
ktsambl	Other
kttm2d	Other
Kupp process shutdown	Other	nalive	sleeptime	loop
kupp process wait	Other
kxfxse	Other	kxfxse debug wait: stalling for slave 0
kxfxsp	Other	kxfxsp debug wait: stalling for slave 0
L1 validation	Other	seghdr	l1bmb
latch activity	Other	address	number	process#
latch free	Other	address	number	tries
latch: cache buffer handles	Other	address	number	tries
latch: cache buffers chains	Concurrency	address	number	tries
latch: cache buffers lru chain	Other	address	number	tries
latch: checkpoint queue latch	Other	address	number	tries
latch: enqueue hash chains	Other	address	number	tries
latch: gcs resource hash	Other	address	number	tries
latch: ges resource hash list	Other	address	number	tries
latch: In memory undo latch	Concurrency	address	number	tries
latch: KCL gc element parent latch	Other	address	number	tries
latch: latch wait list	Other	address	number	tries
latch: library cache	Concurrency	address	number	tries
latch: library cache lock	Concurrency	address	number	tries
latch: library cache pin	Concurrency	address	number	tries
latch: messages	Other	address	number	tries
latch: MQL Tracking Latch	Concurrency	address	number	tries
latch: object queue header heap	Other	address	number	tries
latch: object queue header operation	Other	address	number	tries
latch: parallel query alloc buffer	Other	address	number	tries
latch: redo allocation	Other	address	number	tries
latch: redo copy	Configuration	address	number	tries
latch: redo writing	Configuration	address	number	tries
latch: row cache objects	Other	address	number	tries
latch: session allocation	Other	address	number	tries
latch: shared pool	Configuration	address	number	tries
latch: undo global data	Other	address	number	tries
latch: virtual circuit queues	Other	address	number	tries
LGWR random i/o	System I/O
LGWR sequential i/o	System I/O
LGWR simulation latency wait	Other
LGWR wait for redo copy	Other	copy latch #
LGWR wait on ATTACH	Network
LGWR wait on DETACH	Network
LGWR wait on full LNS buffer	Other
LGWR wait on LNS	Network
LGWR wait on SENDREQ	Network
LGWR-LNS wait on channel	Other
library cache load lock	Concurrency	object address	lock address	100*mask+namespace
library cache lock	Concurrency	handle address	lock address	100*mode+namespace
library cache pin	Concurrency	handle address	pin address	100*mode+namespace
library cache revalidation	Other
listen endpoint status	Other	end-point#	status
LNS simulation latency wait	Other
LNS wait for LGWR redo	Other
LNS wait on ATTACH	Network
LNS wait on DETACH	Network
LNS wait on LGWR	Network
LNS wait on SENDREQ	Network
local write wait	User I/O	file#	block#
lock close	Other	group	lms#
lock deadlock retry	Other
lock escalate retry	Other
lock release pending	Other	group	file#	block#
lock remastering	Cluster
log buffer space	Configuration
log file parallel write	System I/O	files	blocks	requests
log file sequential read	System I/O	log#	block#	blocks
log file single write	System I/O	log#	block#	blocks
log file switch (archiving needed)	Configuration
log file switch (checkpoint incomplete)	Configuration
log file switch (clearing log file)	Configuration
log file switch completion	Configuration
log file sync	Commit	buffer#
log switch/archive	Configuration	thread#
log write(even)	Other	group#
log write(odd)	Other	group#
master exit	Other	alive slaves
master wait	Other
MMON (Lite) shutdown	Other	process#	waited
MMON slave messages	Other
MRP wait on archivelog archival	Other
MRP wait on archivelog arrival	Other
MRP wait on archivelog delay	Other
MRP wait on process death	Other
MRP wait on process restart	Other
MRP wait on process start	Other
MRP wait on startup clear	Other
MRP wait on state change	Other
MRP wait on state n_a	Other
MRP wait on state reset	Other
multiple dbwriter suspend/resume for file offline	Administrative
name-service call wait	Other	waittime
no free buffers	Other	group#	obj#	block#
no free locks	Other
null event	Other
OLAP Aggregate Client Deq	Other	sleeptime/senderid	passes
OLAP Aggregate Client Enq	Other	sleeptime/senderid	passes
OLAP Aggregate Master Deq	Other	sleeptime/senderid	passes
OLAP Aggregate Master Enq	Other	sleeptime/senderid	passes
OLAP Null PQ Reason	Other	sleeptime/senderid	passes
OLAP Parallel Temp Grew	Other	sleeptime/senderid	passes
OLAP Parallel Temp Grow Request	Other	sleeptime/senderid	passes
OLAP Parallel Temp Grow Wait	Other	sleeptime/senderid	passes
OLAP Parallel Type Deq	Other	sleeptime/senderid	passes
opishd	Other
parallel recovery coordinator waits for cleanup of slaves	Idle
pending global transaction(s)	Other	scans
pi renounce write complete	Cluster	file#	block#
pipe get	Idle	handle address	buffer length	timeout
pipe put	Concurrency	handle address	record length	timeout
PL/SQL lock timer	Idle	duration
pmon timer	Idle	duration
process shutdown	Other	type	process#	waited
process startup	Other	type	process#	waited
PX create server	Other	nservers	sleeptime	enqueue
PX Deq Credit: free buffer	Other	sleeptime/senderid	passes	qref
PX Deq Credit: need buffer	Idle	sleeptime/senderid	passes	qref
PX Deq Credit: send blkd	Other	sleeptime/senderid	passes	qref
PX Deq: Execute Reply	Idle	sleeptime/senderid	passes
PX Deq: Execution Msg	Idle	sleeptime/senderid	passes
PX Deq: Index Merge Close	Idle	sleeptime/senderid	passes
PX Deq: Index Merge Execute	Idle	sleeptime/senderid	passes
PX Deq: Index Merge Reply	Idle	sleeptime/senderid	passes
PX Deq: Join ACK	Idle	sleeptime/senderid	passes
PX Deq: kdcph_mai	Idle	kdcph_mai
PX Deq: kdcphc_ack	Idle	kdcphc_ack
PX Deq: Msg Fragment	Idle	sleeptime/senderid	passes
PX Deq: OLAP Update Close	Other	sleeptime/senderid	passes
PX Deq: OLAP Update Execute	Other	sleeptime/senderid	passes
PX Deq: OLAP Update Reply	Other	sleeptime/senderid	passes
PX Deq: Par Recov Change Vector	Idle	sleeptime/senderid	passes
PX Deq: Par Recov Execute	Idle	sleeptime/senderid	passes
PX Deq: Par Recov Reply	Idle	sleeptime/senderid	passes
PX Deq: Parse Reply	Idle	sleeptime/senderid	passes
PX Deq: reap credit	Other
PX Deq: Signal ACK	Other	sleeptime/senderid	passes
PX Deq: Table Q Close	Other	sleeptime/senderid	passes
PX Deq: Table Q Get Keys	Other	sleeptime/senderid	passes
PX Deq: Table Q Normal	Idle	sleeptime/senderid	passes
PX Deq: Table Q qref	Other	sleeptime/senderid	passes
PX Deq: Table Q Sample	Idle	sleeptime/senderid	passes
PX Deq: Test for msg	Other	sleeptime/senderid	passes
PX Deq: Txn Recovery Reply	Idle	sleeptime/senderid	passes
PX Deq: Txn Recovery Start	Idle	sleeptime/senderid	passes
PX Deque wait	Idle	sleeptime/senderid	passes
PX Idle Wait	Idle	sleeptime/senderid	passes
PX Nsq: PQ descriptor query	Other
PX Nsq: PQ load info query	Other
PX qref latch	Other	function	sleeptime	qref
PX Send Wait	Other
PX server shutdown	Other	nalive	sleeptime	loop
PX signal server	Other	serial	error	nbusy
PX slave connection	Other
PX slave release	Other
qerex_gdml	Other
queue messages	Idle	queue id	process#	wait time
Queue Monitor IPC wait	Idle
Queue Monitor Shutdown Wait	Idle
Queue Monitor Slave Wait	Idle
Queue Monitor Task Wait	Other
Queue Monitor Wait	Idle
queue slave messages	Other
rdbms ipc message	Idle	timeout
rdbms ipc message block	Other
rdbms ipc reply	Other	from_process	timeout
read by other session	User I/O	file#	block#	class#
recovery area: computing applied logs	Other
recovery area: computing backed up files	Other
recovery area: computing dropped files	Other
recovery area: computing identical files	Other
recovery area: computing obsolete files	Other
recovery read	System I/O
refresh controlfile command	Administrative
reliable message	Other	channel context	channel handle	broadcast message
Replication Dequeue	Other	sleeptime/senderid	passes
resmgr:become active	Scheduler	location
resmgr:cpu quantum	Scheduler	location
resmgr:internal state change	Concurrency	location
resmgr:internal state cleanup	Concurrency	location
resmgr:sessions to exit	Concurrency	location
retry contact SCN lock master	Cluster
rfc_open_retry	Other	DMON waiting to retry configuration file open
rfi_drcx_site_del	Other	DRCX waiting for site to delete metadata
rfi_insv_shut	Other	wait for INSV to shutdown
rfi_insv_start	Other	wait for INSV to start
rfi_nsv_deldef	Other	NSVx to defer delete response message post to DMON
rfi_nsv_md_close	Other	NSVx metadata file close wait
rfi_nsv_md_write	Other	NSVx metadata file write wait
rfi_nsv_postdef	Other	NSVx to defer message post to DMON
rfi_nsv_shut	Other	wait for NSVx to shutdown
rfi_nsv_start	Other	wait for NSVx to start
rfi_recon1	Other	letting site register with its local listener before connect ret
rfi_recon2	Other	retrying connection for sending to remote DRCX
rfm_dmon_last_gasp	Other	DMON waiting on the last gasp event
rfm_dmon_pdefer	Other	DMON phase deferral wait
rfm_dmon_shut	Other	wait for DMON to shutdown
rfm_dmon_timeout_op	Other	DMON waiting to timeout an operation
rfm_pmon_dso_stall	Other	PMON delete state object stall
rfrdb_dbop	Other	waiting for database to be opened
rfrdb_recon1	Other	reconnecting back to new primary site during standby viability c
rfrdb_recon2	Other	waiting for standby database to be mounted
rfrdb_try235	Other	waiting for retrying the query to mask ORA-235 error
rfrla_lapp1	Other	waiting for logical apply engine to initialize
rfrla_lapp2	Other	checking for logical apply engine run-down progress
rfrla_lapp3	Other	waiting for new primary to initialize tables
rfrla_lapp4	Other	waiting for v$logstdby_stats view to be initialized
rfrla_lapp5	Other	waiting to reconnect to primary that is in BUILD_UP
rfrm_dbcl	Other	RSM notifier: waiting for sql latch on db close
rfrm_dbop	Other	RSM notifier: waiting for sql latch on db open
rfrm_nonzero_sub_count	Other	wait for subscriber count to become nonzero
rfrm_rsm_shut	Other	wait for RSMx processes to shutdown
rfrm_rsm_so_attach	Other	wait for RSMx to attach to state object
rfrm_rsm_start	Other	wait for RSMx processes to start
rfrm_stall	Other	RSM stall due to event RSM_STALL
rfrm_zero_sub_count	Other	wait for subscriber count to become zero
rfrpa_mrpdn	Other	waiting for MRP0 to stop while bringing physical apply engine of
rfrpa_mrpup	Other	waiting for MRP0 to start while bringing physical apply engine o
rfrxpt_pdl	Other	waiting for retrying potential dataloss calculation before switc
rfrxptarcurlog	Other	waiting for logical apply engine to finish initialization
RFS announce	Other
RFS attach	Other
RFS close	Other
RFS create	Other
RFS detach	Other
RFS dispatch	Other
RFS ping	Other
RFS random i/o	System I/O
RFS register	Other
RFS sequential i/o	System I/O
RFS write	System I/O
rollback operations active	Other	operation count
rollback operations block full	Other	max operations
row cache lock	Concurrency	cache id	mode	request
row cache read	Concurrency	cache id	address	times
RVWR wait for flashback copy	Other	copy latch #
scginq AST call	Other
secondary event	Other	event #	wait time
select wait	Other
simulated log write delay	Other
single-task message	Idle
slave exit	Other	nalive	sleeptime	loop
slave shutdown wait	Other
slave TJ process wait	Other
smon timer	Idle	sleep time	failed
sort segment request	Configuration
SQL*Net break/reset to client	Application	driver id	break?
SQL*Net break/reset to dblink	Application	driver id	break?
SQL*Net message from client	Idle	driver id	#bytes
SQL*Net message from dblink	Idle	driver id	#bytes
SQL*Net message to client	Network	driver id	#bytes
SQL*Net message to dblink	Network	driver id	#bytes
SQL*Net more data from client	Network	driver id	#bytes
SQL*Net more data from dblink	Network	driver id	#bytes
SQL*Net more data to client	Network	driver id	#bytes
SQL*Net more data to dblink	Network	driver id	#bytes
statement suspended, wait error to be cleared	Idle
STREAMS apply coord waiting for slave message	Idle
STREAMS apply slave idle wait	Idle
STREAMS apply slave waiting for coord message	Application
STREAMS capture process filter callback wait for ruleset	Idle
STREAMS capture process waiting for archive log	Other
STREAMS fetch slave waiting for txns	Idle
Streams: Wait for inter instance ack	Other
Streams: Wating for DDL to apply	Application	sleep time
switch logfile command	Administrative
switch undo - offline	Administrative
SWRF RWM Auto Capture Event	Other
SWRF Wait on Flushing	Other
Sync ASM rebalance	Other
test long ops	Other
timer in sksawat	Other
trace continue	Other	delay time
trace unfreeze	Other
trace writer flush	Other
trace writer I/O	Other
transaction	Other	undo seg#|slot#	wrap#	count
txn to complete	Other
unbound tx	Other
undo segment extension	Configuration	segment#
undo segment recovery	Other	segment#	tx flags
undo segment tx slot	Configuration	segment#
unspecified wait event	Other
virtual circuit status	Idle	circuit#	status
wait active processes	Other
wait for a paralle reco to abort	Other
wait for a undo record	Other
wait for activate message	Idle
wait for another txn - rollback to savepoint	Other
wait for another txn - txn abort	Other
wait for another txn - undo rcv abort	Other
wait for assert messages to be sent	Other
wait for change	Other
Wait for Dictionary Build to lock all tables	Other
wait for EMON to die	Other
wait for EMON to process ntfns	Configuration
wait for EMON to spawn	Other
wait for FMON to come up	Other
wait for Logical Standby Apply shutdown	Other
wait for master scn	Other	waittime	startscn	ackscn
wait for membership synchronization	Other
wait for message ack	Other
wait for MTTR advisory state object	Other
wait for possible quiesce finish	Administrative
wait for record update	Other
wait for resize request completion	Other
wait for rr lock release	Other
wait for scn ack	Other	pending_nd	scnwrp	scnbas
wait for SGA component shrink	Other	component id	current size	target size
wait for sga_target resize	Other
Wait for shrink lock	Other	object_id	lock_mode
Wait for shrink lock2	Other	object_id	lock_mode
wait for split-brain resolution	Other
wait for stopper event to be increased	Other
wait for sync ack	Other	cluinc	pending_nd
Wait for Table Lock	Application
wait for tmc2 to complete	Other
wait for transaction	Idle
Wait for TT enqueue	Other	tsn
wait for unread message on broadcast channel	Idle	channel context	channel handle
wait for unread message on multiple broadcast channels	Idle	channel context	channel handle count
wait for verification ack	Other	cluinc	pending_insts
wait for votes	Other
wait list latch activity	Other	address	number	process#
wait list latch free	Other	address	number	tries
Wait on stby instance close	Other
waiting for low memory condition to be resolved	Idle
waiting for subscribers to catch up	Idle
waiting to get CAS latch	Other
waiting to get RM CAS latch	Other
wakeup blocked enqueuers	Other
wakeup event for builder	Idle
wakeup event for preparer	Idle
wakeup event for reader	Idle
wakeup time manager	Idle
write complete waits	Configuration	file#	block#
writes stopped by instance recovery or database suspension	Other	by thread#	our thread#

[10g] CRS Log

$ORA_CRS_HOME/crs/log	Contains trace files for the CRS resources.
$ORA_CRS_HOME/crs/init	Contains trace files of the CRS daemon during startup.  Good place to start with any CRS login problems.
$ORA_CRS_HOME/css/log	The Cluster Synchronization (CSS) logs indicate all actions such as reconfigurations,  missed check-ins, connects, and disconnects from the client CSS listener.  In some cases, the logger logs messages with the category of auth.crit for the reboots done by Oracle.  This could be used for checking the exact time when the reboot occurred.
$ORA_CRS_HOME/css/init	Contains core dumps from the Oracle Cluster Synchronization Service daemon (OCSSd)  and the process ID (PID) for the CSS daemon whose death is treated as fatal.  If abnormal restarts for CSS exist, the core files will have the format of core..
$ORA_CRS_HOME/evm/log	Log files for the Event Volume Manager (EVM) and evmlogger daemons.  Not used as often for debugging as the CRS and CSS directories.
$ORA_CRS_HOME/evm/init	PID and lock files for EVM. Core files for EVM should also be written here.
$ORA_CRS_HOME/srvm/log	Log files for Oracle Cluster Registry (OCR), which contains the details at the Oracle cluster level.
$ORA_CRS_HOME/log	Log files for Oracle Clusterware (known as the cluster alert log),  which contains diagnostic messages at the Oracle cluster level.  This is available from Oracle database 10g R2.

출처 :http://www.adminschool.net/dbwiki/doku.php?id=dbms:oracle:crs