11gR2待機イベント一覧

・P1～P3は待機イベントの補足情報でV$SESSION_WAITやV$ACTIVE_SESSION_HISTORY(10g～)を問い合わせることでそのタイミングの補足情報を確認することができます。
・wait classは待機イベントの分類を表します。

event name	P1	P2	P3	wait class
Backup: MML initialization				Administrative
Backup: MML v1 open backup piece				Administrative
Backup: MML v1 read backup piece				Administrative
Backup: MML v1 write backup piece				Administrative
Backup: MML v1 close backup piece				Administrative
Backup: MML v1 query backup piece				Administrative
Backup: MML v1 delete backup piece				Administrative
Backup: MML create a backup piece				Administrative
Backup: MML commit backup piece				Administrative
Backup: MML command to channel				Administrative
Backup: MML shutdown				Administrative
Backup: MML obtain textual error				Administrative
Backup: MML query backup piece				Administrative
Backup: MML extended initialization				Administrative
Backup: MML read backup piece				Administrative
Backup: MML delete backup piece				Administrative
Backup: MML restore backup piece				Administrative
Backup: MML write backup piece				Administrative
Backup: MML proxy initialize backup				Administrative
Backup: MML proxy cancel				Administrative
Backup: MML proxy commit backup piece				Administrative
Backup: MML proxy session end				Administrative
Backup: MML datafile proxy backup?				Administrative
Backup: MML datafile proxy restore?				Administrative
Backup: MML proxy initialize restore				Administrative
Backup: MML proxy start data movement				Administrative
Backup: MML data movement done?				Administrative
Backup: MML proxy prepare to start				Administrative
Backup: MML obtain a direct buffer				Administrative
Backup: MML release a direct buffer				Administrative
Backup: MML get base address				Administrative
Backup: MML query for direct buffers				Administrative
multiple dbwriter suspend/resume for file offline				Administrative
db flash cache dynamic disabling wait				Administrative
switch logfile command				Administrative
enq: MV - datafile move	name|mode	type	file #	Administrative
wait for possible quiesce finish				Administrative
concurrent I/O completion				Administrative
datafile copy range completion				Administrative
switch undo - offline				Administrative
alter rbs offline				Administrative
enq: TW - contention	name|mode	0	operation	Administrative
index (re)build online start	object	mode	wait	Administrative
index (re)build online cleanup	object	mode	wait	Administrative
index (re)build online merge	object	mode	wait	Administrative
alter system set dispatcher	waited			Administrative
connection pool wait	op	num servers		Administrative
enq: DB - contention	name|mode	EnqMode	0	Administrative
enq: ZG - contention	name|mode	file group id	version id	Administrative
ASM COD rollback operation completion	dismount force			Administrative
ASM mount : wait for heartbeat				Administrative
JS kgl get object wait				Administrative
JS kill job wait				Administrative
JS coord start wait				Administrative
enq: PW - flush prewarm buffers	name|mode	0	0	Application
enq: RO - contention	name|mode	2	0	Application
enq: RO - fast object reuse	name|mode	2	0	Application
enq: KO - fast object checkpoint	name|mode	2	0	Application
enq: TM - contention	name|mode	object #	table/partition	Application
enq: TX - row lock contention	name|mode	usn<<16 | slot	sequence	Application
Wait for Table Lock				Application
enq: RC - Result Cache: Contention	name|mode	chunkNo	blockNo	Application
Streams capture: filter callback waiting for ruleset				Application
Streams: apply reader waiting for DDL to apply	sleep time			Application
SQL*Net break/reset to client	driver id	break?		Application
SQL*Net break/reset to dblink	driver id	break?		Application
External Procedure initial connection				Application
External Procedure call				Application
enq: UL - contention	name|mode	id	0	Application
OLAP DML Sleep	duration			Application
WCR: replay lock order	wait for scn's hi 4 bytes	wait for scn's lo 4 bytes		Application
retry contact SCN lock master				Cluster
gc buffer busy acquire	file#	block#	class#	Cluster
gc buffer busy release	file#	block#	class#	Cluster
pi renounce write complete	file#	block#		Cluster
gc current request	file#	block#	id#	Cluster
gc cr request	file#	block#	class#	Cluster
gc cr disk request	file#	block#	class#	Cluster
gc cr multi block request	file#	block#	class#	Cluster
gc current multi block request	file#	block#	id#	Cluster
gc block recovery request	file#	block#	class#	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 failure				Cluster
gc cr block lost				Cluster
gc cr block unknown				Cluster
gc current block 2-way				Cluster
gc current block 3-way				Cluster
gc current block busy				Cluster
gc current block congested				Cluster
gc current retry				Cluster
gc current block lost				Cluster
gc current split				Cluster
gc current block unknown				Cluster
gc cr grant 2-way				Cluster
gc cr grant busy				Cluster
gc cr grant congested				Cluster
gc cr grant unknown				Cluster
gc cr disk read				Cluster
gc current grant 2-way				Cluster
gc current grant busy				Cluster
gc current grant congested				Cluster
gc current grant unknown				Cluster
gc freelist				Cluster
gc remaster	file#	block#	class#	Cluster
gc quiesce				Cluster
gc object scan				Cluster
gc recovery				Cluster
gc flushed buffer				Cluster
gc current cancel	le			Cluster
gc cr cancel	le			Cluster
gc assume	le			Cluster
gc domain validation	file#	block#	class#	Cluster
gc recovery free				Cluster
gc recovery quiesce	file#	block#	class#	Cluster
gc claim				Cluster
gc cancel retry				Cluster
ASM PST query : wait for [PM][grp][0] grant				Cluster
lock remastering				Cluster
log file sync	buffer#	sync scn		Commit
enq: BB - 2PC across RAC instances	name|mode	gtrid hash value	bqual hash value	Commit
logout restrictor				Concurrency
os thread startup				Concurrency
Shared IO Pool Memory				Concurrency
latch: cache buffers chains	address	number	tries	Concurrency
buffer busy waits	file#	block#	class#	Concurrency
db flash cache invalidate wait				Concurrency
enq: TX - index contention	name|mode	usn<<16 | slot	sequence	Concurrency
latch: Undo Hint Latch	address	number	tries	Concurrency
latch: In memory undo latch	address	number	tries	Concurrency
latch: MQL Tracking Latch	address	number	tries	Concurrency
securefile chain update	seghdr	fsb		Concurrency
SecureFile mutex				Concurrency
enq: WG - lock fso	name|mode	kdlw lobid first half	kdlw lobid sec half	Concurrency
latch: row cache objects	address	number	tries	Concurrency
row cache lock	cache id	mode	request	Concurrency
row cache read	cache id	address	times	Concurrency
cursor: mutex X	idn	value	where	Concurrency
cursor: mutex S	idn	value	where	Concurrency
cursor: pin X	idn	value	where	Concurrency
cursor: pin S	idn	value	where	Concurrency
cursor: pin S wait on X	idn	value	where	Concurrency
latch: shared pool	address	number	tries	Concurrency
library cache pin	handle address	pin address	100*mode+namespace	Concurrency
library cache lock	handle address	lock address	100*mode+namespace	Concurrency
library cache load lock	object address	lock address	100*mask+namespace	Concurrency
library cache: mutex X	idn	value	where	Concurrency
library cache: mutex S	idn	value	where	Concurrency
resmgr:internal state change	location			Concurrency
resmgr:internal state cleanup	location			Concurrency
resmgr:sessions to exit	location			Concurrency
pipe put	handle address	record length	timeout	Concurrency
Streams apply: waiting for dependency				Concurrency
free buffer waits	file#	block#	set-id#	Configuration
checkpoint completed				Configuration
write complete waits	file#	block#		Configuration
write complete waits: flash cache	file#	block#		Configuration
latch: redo writing	address	number	tries	Configuration
latch: redo copy	address	number	tries	Configuration
log buffer space				Configuration
log file switch (checkpoint incomplete)				Configuration
log file switch (private strand flush incomplete)				Configuration
log file switch (archiving needed)				Configuration
log file switch completion				Configuration
flashback buf free by RVWR				Configuration
enq: ST - contention	name|mode	0	0	Configuration
undo segment extension	segment#			Configuration
undo segment tx slot	segment#			Configuration
enq: TX - allocate ITL entry	name|mode	usn<<16 | slot	sequence	Configuration
statement suspended, wait error to be cleared				Configuration
enq: HW - contention	name|mode	table space #	block	Configuration
enq: SS - contention	name|mode	tablespace #	dba	Configuration
sort segment request				Configuration
enq: SQ - contention	name|mode	object #	0	Configuration
Global transaction acquire instance locks	retries			Configuration
Streams apply: waiting to commit				Configuration
wait for EMON to process ntfns				Configuration
pmon timer	duration			Idle
VKTM Logical Idle Wait				Idle
VKTM Init Wait for GSGA				Idle
IORM Scheduler Slave Idle Wait				Idle
rdbms ipc message	timeout			Idle
i/o slave wait	msg ptr			Idle
VKRM Idle				Idle
wait for unread message on broadcast channel	channel context	channel handle		Idle
wait for unread message on multiple broadcast channels	channel context	channel handle count		Idle
class slave wait	slave id			Idle
KSV master wait				Idle
PING				Idle
watchdog main loop				Idle
DIAG idle wait	component	where	wait time(millisec)	Idle
ges remote message	waittime	loop	p3	Idle
gcs remote message	waittime	poll	event	Idle
heartbeat monitor sleep				Idle
SGA: MMAN sleep for component shrink	component id	current size	target size	Idle
MRP redo arrival				Idle
LNS ASYNC archive log				Idle
LNS ASYNC dest activation				Idle
LNS ASYNC end of log				Idle
simulated log write delay				Idle
LGWR real time apply sync				Idle
parallel recovery slave idle wait				Idle
LogMiner builder: idle	Session ID			Idle
LogMiner builder: branch	Session ID			Idle
LogMiner preparer: idle	Session ID			Idle
LogMiner reader: log (idle)	Session ID	Thread	Sequence	Idle
LogMiner reader: redo (idle)	Session ID	Thread	Sequence	Idle
LogMiner client: transaction	Session ID			Idle
LogMiner: other	Session ID			Idle
LogMiner: activate	Session ID			Idle
LogMiner: reset	Caller ID			Idle
LogMiner: find session	Session ID			Idle
LogMiner: internal	Caller ID			Idle
Logical Standby Apply Delay				Idle
parallel recovery coordinator waits for slave cleanup				Idle
parallel recovery control message reply				Idle
parallel recovery slave next change				Idle
PX Deq: Txn Recovery Start	sleeptime/senderid	passes		Idle
PX Deq: Txn Recovery Reply	sleeptime/senderid	passes		Idle
fbar timer	sleep time	failed		Idle
smon timer	sleep time	failed		Idle
PX Deq: Metadata Update	ktelc_wait1s			Idle
Space Manager: slave idle wait	Slave ID			Idle
PX Deq: Index Merge Reply	sleeptime/senderid	passes		Idle
PX Deq: Index Merge Execute	sleeptime/senderid	passes		Idle
PX Deq: Index Merge Close	sleeptime/senderid	passes		Idle
PX Deq: kdcph_mai	kdcph_mai			Idle
PX Deq: kdcphc_ack	kdcphc_ack			Idle
shared server idle wait				Idle
dispatcher timer	sleep time			Idle
cmon timer	sleep time			Idle
pool server timer	sleep time			Idle
JOX Jit Process Sleep				Idle
jobq slave wait				Idle
pipe get	handle address	buffer length	timeout	Idle
PX Deque wait	sleeptime/senderid	passes		Idle
PX Idle Wait	sleeptime/senderid	passes		Idle
PX Deq: Join ACK	sleeptime/senderid	passes		Idle
PX Deq Credit: need buffer	sleeptime/senderid	passes	qref	Idle
PX Deq Credit: send blkd	sleeptime/senderid	passes	qref	Idle
PX Deq: Msg Fragment	sleeptime/senderid	passes		Idle
PX Deq: Parse Reply	sleeptime/senderid	passes		Idle
PX Deq: Execute Reply	sleeptime/senderid	passes		Idle
PX Deq: Execution Msg	sleeptime/senderid	passes		Idle
PX Deq: Table Q Normal	sleeptime/senderid	passes		Idle
PX Deq: Table Q Sample	sleeptime/senderid	passes		Idle
Streams fetch slave: waiting for txns				Idle
Streams: waiting for messages				Idle
Streams capture: waiting for archive log				Idle
single-task message				Idle
SQL*Net message from client	driver id	#bytes		Idle
SQL*Net vector message from client	driver id	#bytes		Idle
SQL*Net vector message from dblink	driver id	#bytes		Idle
PL/SQL lock timer	duration			Idle
Streams AQ: emn coordinator idle wait				Idle
EMON slave idle wait				Idle
Streams AQ: waiting for messages in the queue	queue id	process#	wait time	Idle
Streams AQ: waiting for time management or cleanup tasks				Idle
Streams AQ: delete acknowledged messages				Idle
Streams AQ: deallocate messages from Streams Pool				Idle
Streams AQ: qmn coordinator idle wait				Idle
Streams AQ: qmn slave idle wait	Type			Idle
Streams AQ: RAC qmn coordinator idle wait				Idle
HS message to agent				Idle
ASM background timer				Idle
auto-sqltune: wait graph update				Idle
WCR: replay client notify	who am I			Idle
WCR: replay clock	wait for scn's hi 4 bytes	wait for scn's lo 4 bytes		Idle
WCR: replay paused				Idle
JS external job				Idle
cell worker idle				Idle
remote db operation	clientid	operation	timeout	Network
remote db file read	clientid	count	intr	Network
remote db file write	clientid	count	intr	Network
ARCH wait for net re-connect				Network
LGWR wait on ATTACH				Network
ARCH wait on ATTACH				Network
ARCH wait for netserver start				Network
LNS wait on ATTACH				Network
LNS wait on SENDREQ				Network
LNS wait on DETACH				Network
LGWR wait on SENDREQ				Network
LGWR wait on DETACH				Network
ARCH wait on SENDREQ				Network
ARCH wait on DETACH				Network
ARCH wait for netserver init 2				Network
LNS wait on LGWR				Network
LGWR wait on LNS				Network
ARCH wait for flow-control				Network
ARCH wait for netserver detach				Network
TCP Socket (KGAS)				Network
virtual circuit wait	circuit#	type		Network
dispatcher listen timer	sleep time			Network
dedicated server timer	wait event			Network
SQL*Net message to client	driver id	#bytes		Network
SQL*Net message to dblink	driver id	#bytes		Network
SQL*Net more data to client	driver id	#bytes		Network
SQL*Net more data to dblink	driver id	#bytes		Network
SQL*Net more data from client	driver id	#bytes		Network
SQL*Net message from dblink	driver id	#bytes		Network
SQL*Net more data from dblink	driver id	#bytes		Network
SQL*Net vector data to client	driver id	#bytes		Network
SQL*Net vector data from client	driver id	#bytes		Network
SQL*Net vector data to dblink	driver id	#bytes		Network
SQL*Net vector data from dblink	driver id	#bytes		Network
TEXT: URL_DATASTORE network wait				Network
null event				Other
events in waitclass Other				Other
enq: WM - WLM Plan activation	name|mode	0	0	Other
latch free	address	number	tries	Other
kslwait unit test event 1	p1	p2	p3	Other
kslwait unit test event 2	p1	p2	p3	Other
kslwait unit test event 3	p1	p2	p3	Other
unspecified wait event				Other
latch activity	address	number	process#	Other
wait list latch activity	address	number	process#	Other
wait list latch free	address	number	tries	Other
global enqueue expand wait				Other
free process state object				Other
inactive session	session#	waited	instance|serial	Other
process terminate				Other
latch: call allocation	address	number	tries	Other
latch: session allocation	address	number	tries	Other
check CPU wait times				Other
enq: CI - contention	name|mode	opcode	type	Other
enq: PR - contention	name|mode	0	0	Other
ksim generic wait event	where	wait_count		Other
debugger command				Other
ksdxexeother				Other
ksdxexeotherwait				Other
enq: PE - contention	name|mode	parno	0	Other
enq: PG - contention	name|mode	0	0	Other
ksbsrv				Other
ksbcic				Other
process startup	type	process#	waited	Other
process shutdown	type	process#	waited	Other
prior spawner clean up	process_pid	process_sno		Other
latch: messages	address	number	tries	Other
rdbms ipc message block				Other
rdbms ipc reply	from_process	timeout		Other
latch: enqueue hash chains	address	number	tries	Other
enq: FP - global fob contention	name|mode	low file obj add	high file obj add	Other
enq: RE - block repair contention	name|mode	File Type or File number	block number	Other
asynch descriptor resize	outstanding #aio	current aio limit	new aio limit	Other
imm op	msg ptr			Other
slave exit	nalive	sleeptime	loop	Other
enq: KD - determine DBRM master	name|mode	0	0	Other
enq: KM - contention	name|mode	type	type	Other
enq: KT - contention	name|mode	plan #	0	Other
enq: CA - contention	name|mode	0	0	Other
reliable message	channel context	channel handle	broadcast message	Other
broadcast mesg queue transition	channel handle	message	location	Other
broadcast mesg recovery queue transition	channel handle	message	location	Other
master exit	alive slaves			Other
ksv slave avail wait				Other
enq: PV - syncstart	name|mode	0	0	Other
enq: PV - syncshut	name|mode	0	0	Other
enq: SP - contention	name|mode	id1	id2	Other
enq: SP - contention 2	name|mode	id1	id2	Other
enq: SP - contention 3	name|mode	id1	id2	Other
enq: SP - contention 4	name|mode	id1	id2	Other
IPC send completion sync	send count			Other
OSD IPC library	rolling mig			Other
IPC wait for name service busy				Other
IPC busy async request				Other
IPC waiting for OSD resources				Other
ksxr poll remote instances				Other
ksxr wait for mount shared				Other
DBMS_LDAP: LDAP operation				Other
wait for FMON to come up				Other
enq: FM - contention	name|mode	0	0	Other
enq: XY - contention	name|mode	id1	id2	Other
set director factor wait				Other
enq: AS - service activation	name|mode	0	0	Other
enq: PD - contention	name|mode	property name	key hash	Other
cleanup of aborted process	location			Other
enq: RU - contention	name|mode	0	0	Other
enq: RU - waiting	name|mode	0	0	Other
rolling migration: cluster quiesce	location	waits		Other
LMON global data update				Other
process diagnostic dump				Other
enq: MX - sync storage server info	name|mode	nodeid	instanceid	Other
master diskmon startup				Other
pmon dblkr tst event	index			Other
latch: ges resource hash list	address	number	tries	Other
DFS lock handle	type|mode	id1	id2	Other
ges LMD to shutdown				Other
ges client process to exit				Other
ges global resource directory to be frozen	location			Other
ges resource directory to be unfrozen				Other
gcs resource directory to be unfrozen				Other
ges LMD to inherit communication channels				Other
ges lmd sync during reconfig	location			Other
ges wait for lmon to be ready				Other
ges cgs registration	where			Other
wait for master scn	waittime	startscn	ackscn	Other
ges yield cpu in reconfig	location			Other
ges2 proc latch in rm latch get 1				Other
ges2 proc latch in rm latch get 2				Other
ges lmd/lmses to freeze in rcfg	lmd/lms id			Other
ges lmd/lmses to unfreeze in rcfg	lmd/lms id			Other
ges lms sync during dynamic remastering and reconfig	location	lms id		Other
ges LMON to join CGS group				Other
ges pmon to exit				Other
ges lmd and pmon to attach				Other
gcs drm freeze begin				Other
gcs retry nowait latch get	location			Other
gcs remastering wait for read latch				Other
ges cached resource cleanup	waittime			Other
ges generic event				Other
ges retry query node				Other
ges process with outstanding i/o	pid			Other
ges user error	error			Other
ges enter server mode				Other
gcs enter server mode				Other
gcs drm freeze in enter server mode				Other
gcs ddet enter server mode				Other
ges cancel				Other
ges resource cleanout during enqueue open				Other
ges resource cleanout during enqueue open-cvt				Other
ges master to get established for SCN op				Other
ges LMON to get to FTDONE				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
ges inquiry response	type|mode|where	id1	id2	Other
ges reusing os pid	pid	count		Other
ges LMON for send queues				Other
ges LMD suspend for testing event				Other
ges performance test completion				Other
kjbopen wait for recovery domain attach				Other
kjudomatt wait for recovery domain attach				Other
kjudomdet wait for recovery domain detach				Other
kjbdomalc allocate recovery domain - retry				Other
kjbdrmcvtq lmon drm quiesce: ping completion	location	lms id		Other
ges RMS0 retry add redo log				Other
readable standby redo apply remastering				Other
ges DFS hang analysis phase 2 acks				Other
ges/gcs diag dump	location			Other
global plug and play automatic resource creation	where			Other
gcs lmon dirtydetach step completion	domain id	location		Other
recovery instance recovery completion				Other
KJC: Wait for msg sends to complete	msg	dest|rcvr	mtype	Other
ges message buffer allocation	pool	request	allocated	Other
kjctssqmg: quick message send wait				Other
kjctcisnd: Queue/Send client message				Other
gcs domain validation	cluinc	rcvinc		Other
latch: gcs resource hash	address	number	tries	Other
affinity expansion in replay				Other
wait for sync ack	cluinc	pending_nd		Other
wait for verification ack	cluinc	pending_insts		Other
wait for assert messages to be sent				Other
wait for scn ack	pending_nd	scnwrp	scnbas	Other
lms flush message acks	id			Other
name-service call wait	waittime			Other
CGS wait for IPC msg				Other
kjxgrtest				Other
IMR mount phase II completion				Other
IMR disk votes				Other
IMR rr lock release				Other
IMR net-check message ack				Other
IMR rr update				Other
IMR membership resolution				Other
IMR CSS join retry	retry count			Other
CGS skgxn join retry	retry count			Other
gcs to be enabled				Other
gcs log flush sync	waittime	poll	event	Other
SGA: allocation forcing component growth				Other
SGA: sga_target resize				Other
control file heartbeat				Other
control file diagnostic dump	type	param		Other
enq: CF - contention	name|mode	0	operation	Other
enq: SW - contention	name|mode	0	0	Other
enq: DS - contention	name|mode	0	0	Other
enq: TC - contention	name|mode	checkpoint ID	0	Other
enq: TC - contention2	name|mode	checkpoint ID	0	Other
buffer exterminate	file#	block#	buf_ptr	Other
buffer resize				Other
latch: cache buffers lru chain	address	number	tries	Other
enq: PW - perwarm status in dbw0	name|mode	0	0	Other
latch: checkpoint queue latch	address	number	tries	Other
latch: cache buffer handles	address	number	tries	Other
kcbzps				Other
DBWR range invalidation sync	dbwr#			Other
buffer deadlock	dba	class*10+mode	flag	Other
buffer latch	latch addr	chain#		Other
cr request retry	file#	block#		Other
writes stopped by instance recovery or database suspension	by thread#	our thread#		Other
lock escalate retry				Other
lock deadlock retry				Other
prewarm transfer retry				Other
recovery buffer pinned	file#	block#		Other
TSE master key rekey	ts#			Other
TSE SSO wallet reopen				Other
enq: CR - block range reuse ckpt	name|mode	2	0	Other
wait for MTTR advisory state object				Other
latch: object queue header operation	address	number	tries	Other
Wait on stby instance close				Other
ARCH wait for archivelog lock				Other
enq: WL - Test access/locking	name|mode	log # / thread id #	sequence #	Other
FAL archive wait 1 sec for REOPEN minimum				Other
TEST: action sync				Other
TEST: action hang				Other
RSGA: RAC reconfiguration				Other
enq: WL - RAC-wide SGA contention	name|mode	log # / thread id #	sequence #	Other
LGWR ORL/NoExp FAL archival				Other
MRP wait on process start				Other
MRP wait on process restart				Other
MRP wait on startup clear				Other
MRP wait on process death				Other
MRP wait on state change				Other
MRP wait on state n_a				Other
MRP wait on state reset				Other
MRP wait on archivelog delay				Other
MRP wait on archivelog arrival				Other
MRP wait on archivelog archival				Other
log switch/archive	thread#			Other
ARCH wait on c/f tx acquire 1				Other
RFS attach				Other
RFS create				Other
RFS close				Other
RFS announce				Other
RFS register				Other
RFS detach				Other
RFS ping				Other
RFS dispatch				Other
enq: WL - RFS global state contention	name|mode	log # / thread id #	sequence #	Other
LGWR simulation latency wait				Other
LNS simulation latency wait				Other
ARCH wait for process start 1				Other
ARCH wait for process death 1				Other
ARCH wait for process start 3				Other
Data Guard: process exit				Other
Data Guard: process clean up				Other
LGWR-LNS wait on channel				Other
enq: WR - contention	name|mode	thread id #	sequence #	Other
LGWR wait for redo copy	copy latch #			Other
latch: redo allocation	address	number	tries	Other
log file switch (clearing log file)				Other
enq: WL - contention	name|mode	log # / thread id #	sequence #	Other
enq: RN - contention	name|mode	thread number	log number	Other
DFS db file lock	file#			Other
enq: DF - contention	name|mode	0	file #	Other
enq: IS - contention	name|mode	0	type	Other
enq: FS - contention	name|mode	0	type	Other
enq: DM - contention	name|mode	type	type	Other
enq: RP - contention	name|mode	file #	1 or block	Other
latch: gc element	address	number	tries	Other
enq: RT - contention	name|mode	redo thread	type	Other
enq: RT - thread internal enable/disable	name|mode	redo thread	type	Other
enq: IR - contention	name|mode	0	0/1	Other
enq: IR - contention2	name|mode	0	0/1	Other
enq: MR - contention	name|mode	0 or file #	type	Other
enq: MR - standby role transition	name|mode	0 or file #	type	Other
parallel recovery coord wait for reply				Other
parallel recovery coord send blocked				Other
parallel recovery slave wait for change				Other
enq: BR - file shrink	name|mode	operation	file #	Other
enq: BR - proxy-copy	name|mode	operation	file #	Other
enq: BR - multi-section restore header	name|mode	operation	file #	Other
enq: BR - multi-section restore section	name|mode	operation	file #	Other
enq: BR - space info datafile hdr update	name|mode	operation	file #	Other
enq: BR - request autobackup	name|mode	operation	file #	Other
enq: BR - perform autobackup	name|mode	operation	file #	Other
enq: ID - contention	name|mode	0	0	Other
Backup Restore Throttle sleep	session_id	serial		Other
Backup Restore Switch Bitmap sleep	session_id	serial		Other
Backup Restore Event 19778 sleep	session_id	serial		Other
enq: AB - ABMR process start/stop	name|mode	operation	operation parm	Other
enq: AB - ABMR process initialized	name|mode	operation	operation parm	Other
Auto BMR completion	file#	block#		Other
Auto BMR RPC standby catchup	wrap	base		Other
enq: MN - contention	name|mode	session ID	0	Other
enq: PL - contention	name|mode	0	0	Other
enq: SB - contention	name|mode	0	0	Other
Logical Standby Apply shutdown				Other
Logical Standby pin transaction	xidusn	xidslt	xidsqn	Other
Logical Standby dictionary build				Other
Logical Standby Terminal Apply	stage			Other
Logical Standby Debug	event			Other
enq: XR - quiesce database	name|mode	operation	0	Other
enq: XR - database force logging	name|mode	operation	0	Other
standby query scn advance				Other
change tracking file synchronous read	block#	blocks		Other
change tracking file synchronous write	block#	blocks		Other
change tracking file parallel write	blocks	requests		Other
block change tracking buffer space				Other
CTWR media recovery checkpoint request				Other
enq: CT - global space management	name|mode	operation	operation parm	Other
enq: CT - local space management	name|mode	operation	operation parm	Other
enq: CT - change stream ownership	name|mode	operation	operation parm	Other
enq: CT - state	name|mode	operation	operation parm	Other
enq: CT - state change gate 1	name|mode	operation	operation parm	Other
enq: CT - state change gate 2	name|mode	operation	operation parm	Other
enq: CT - CTWR process start/stop	name|mode	operation	operation parm	Other
enq: CT - reading	name|mode	operation	operation parm	Other
recovery area: computing dropped files				Other
recovery area: computing obsolete files				Other
recovery area: computing backed up files				Other
recovery area: computing applied logs				Other
enq: RS - file delete	name|mode	record type	record id	Other
enq: RS - record reuse	name|mode	record type	record id	Other
enq: RS - prevent file delete	name|mode	record type	record id	Other
enq: RS - prevent aging list update	name|mode	record type	record id	Other
enq: RS - persist alert level	name|mode	record type	record id	Other
enq: RS - read alert level	name|mode	record type	record id	Other
enq: RS - write alert level	name|mode	record type	record id	Other
enq: FL - Flashback database log	name|mode	Log #	zero	Other
enq: FL - Flashback db command	name|mode	Log #	zero	Other
enq: FD - Marker generation	name|mode	Internal	Internal	Other
enq: FD - Tablespace flashback on/off	name|mode	Internal	Internal	Other
enq: FD - Flashback coordinator	name|mode	Internal	Internal	Other
enq: FD - Flashback on/off	name|mode	Internal	Internal	Other
enq: FD - Restore point create/drop	name|mode	Internal	Internal	Other
enq: FD - Flashback logical operations	name|mode	Internal	Internal	Other
flashback free VI log				Other
flashback log switch				Other
RVWR wait for flashback copy	copy latch #			Other
parallel recovery read buffer free				Other
parallel recovery change buffer free				Other
cell smart flash unkeep	cellhash#			Other
datafile move cleanup during resize				Other
blocking txn id for DDL	table	scn	only dml	Other
transaction	undo seg#|slot#	wrap#	count	Other
inactive transaction branch	branch#	waited		Other
txn to complete				Other
PMON to cleanup pseudo-branches at svc stop time				Other
PMON to cleanup detached branches at shutdown				Other
test long ops				Other
latch: undo global data	address	number	tries	Other
undo segment recovery	segment#	tx flags		Other
unbound tx				Other
wait for change				Other
wait for another txn - undo rcv abort				Other
wait for another txn - txn abort				Other
wait for another txn - rollback to savepoint				Other
undo_retention publish retry	where	retry_count		Other
enq: TA - contention	name|mode	operation	undo segment # / other	Other
enq: TX - contention	name|mode	usn<<16 | slot	sequence	Other
enq: US - contention	name|mode	undo segment #	0	Other
wait for stopper event to be increased				Other
wait for a undo record				Other
wait for a paralle reco to abort				Other
enq: IM - contention for blr	name|mode	pool #	0	Other
enq: TD - KTF dump entries	name|mode	0	0	Other
enq: TE - KTF broadcast	name|mode	0	0	Other
enq: CN - race with txn	name|mode	reg id	0	Other
enq: CN - race with reg	name|mode	reg id	0	Other
enq: CN - race with init	name|mode	reg id	0	Other
latch: Change Notification Hash table latch	address	number	tries	Other
enq: CO - master slave det	name|mode	inst id	0	Other
enq: FE - contention	name|mode	0	0	Other
latch: change notification client cache latch	address	number	tries	Other
enq: TF - contention	name|mode	tablespace #	relative file #	Other
latch: lob segment hash table latch	address	number	tries	Other
latch: lob segment query latch	address	number	tries	Other
latch: lob segment dispenser latch	address	number	tries	Other
Wait for shrink lock2	object_id	lock_mode		Other
Wait for shrink lock	object_id	lock_mode		Other
L1 validation	seghdr	l1bmb		Other
Wait for TT enqueue	tsn			Other
kttm2d				Other
ktsambl				Other
ktfbtgex	tsn			Other
enq: DT - contention	name|mode	0	0	Other
enq: TS - contention	name|mode	tablespace ID	dba	Other
enq: FB - contention	name|mode	tablespace #	dba	Other
enq: SK - contention	name|mode	tablespace #	dba	Other
enq: DW - contention	name|mode	tablespace #	dba	Other
enq: SU - contention	name|mode	table space #	0	Other
enq: TT - contention	name|mode	tablespace ID	operation	Other
ktm: instance recovery	undo segment#			Other
instance state change	layer	value	waited	Other
enq: SJ - Slave Task Cancel	name|mode	Slave process id	task id	Other
Space Manager: slave messages				Other
index block split	rootdba	level	childdba	Other
enq: HV - contention	name|mode	object #	0	Other
kdblil wait before retrying ORA-54				Other
dupl. cluster key	dba			Other
kdic_do_merge				Other
enq: DL - contention	name|mode	object #	0	Other
enq: HQ - contention	name|mode	object #	hash value	Other
enq: HP - contention	name|mode	tablespace #	dba	Other
enq: WG - delete fso	name|mode	kdlw lobid first half	kdlw lobid sec half	Other
enq: SL - get lock	name|mode	kdlw lobid first half	kdlw lobid sec half	Other
enq: SL - escalate lock	name|mode	kdlw lobid first half	kdlw lobid sec half	Other
enq: SL - get lock for undo	name|mode	kdlw lobid first half	kdlw lobid sec half	Other
enq: ZH - compression analysis	name|mode	obj#	ulevel	Other
Compression analysis				Other
enq: DV - contention	name|mode	object #	0	Other
enq: SO - contention	name|mode	object #	0	Other
enq: TP - contention	name|mode	0	0	Other
enq: RW - MV metadata contention	name|mode	table obj#	0	Other
enq: OC - contention	name|mode	1	2	Other
enq: OL - contention	name|mode	hash value	0	Other
kkdlgon				Other
kkdlsipon				Other
kkdlhpon				Other
kgltwait				Other
kksfbc research				Other
kksscl hash split				Other
kksfbc child completion				Other
enq: CU - contention	name|mode	handle	handle	Other
enq: AE - lock	name|mode	edition obj#	0	Other
enq: PF - contention	name|mode	0	0	Other
enq: IL - contention	name|mode	object #	0	Other
enq: CL - drop label	name|mode	object #	0	Other
enq: CL - compare labels	name|mode	object #	0	Other
enq: MK - contention	name|mode	0	0	Other
enq: OW - initialization	name|mode	0	0	Other
enq: OW - termination	name|mode	0	0	Other
enq: RK - set key	name|mode	0	0	Other
enq: RL - RAC wallet lock	name|mode	0	0	Other
enq: ZZ - update hash tables	name|mode	KSBXIC Action	0	Other
enq: AU - audit index file	name|mode	XML audit index file	0	Other
enq: ZA - add std audit table partition	name|mode	KZAM Aud Partition	0	Other
enq: ZF - add fga audit table partition	name|mode	KZAM Fga Partition	0	Other
enq: DX - contention	name|mode	transaction entry #	0	Other
enq: DR - contention	name|mode	0	0	Other
pending global transaction(s)	scans			Other
free global transaction table entry	tries			Other
library cache revalidation				Other
library cache shutdown				Other
BFILE closure				Other
BFILE check if exists				Other
BFILE check if open				Other
BFILE get length				Other
BFILE get name object				Other
BFILE get path object				Other
BFILE open				Other
BFILE internal seek				Other
waiting to get CAS latch				Other
waiting to get RM CAS latch				Other
xdb schema cache initialization				Other
ASM cluster file access	lock	mode		Other
CSS initialization				Other
CSS group registration	group_name1	group_name2	mem_id	Other
CSS group membership query	group_name1	group_name2	group_name3	Other
CSS operation: data query	function_id			Other
CSS operation: data update	function_id			Other
CSS Xgrp shared operation	function_id			Other
CSS operation: query	function_id			Other
CSS operation: action	function_id			Other
CSS operation: diagnostic	function_id			Other
GIPC operation: dump	function_id			Other
GPnP Initialization				Other
GPnP Termination				Other
GPnP Get Item				Other
GPnP Set Item				Other
GPnP Get Error				Other
ADR file lock				Other
ADR block file read				Other
ADR block file write				Other
CRS call completion	clsrrestype	kjha_action		Other
dispatcher shutdown	waited			Other
listener registration dump	dump			Other
latch: virtual circuit queues	address	number	tries	Other
listen endpoint status	end-point#	status		Other
OJVM: Generic				Other
select wait				Other
jobq slave shutdown wait				Other
jobq slave TJ process wait				Other
job scheduler coordinator slave wait				Other
enq: JD - contention	name|mode	0	0	Other
enq: JQ - contention	name|mode	0	0	Other
enq: OD - Serializing DDLs	name|mode	object #	0	Other
kkshgnc reloop				Other
optimizer stats update retry				Other
wait active processes				Other
SUPLOG PL wait for inflight pragma-d PL/SQL	session_num			Other
enq: MD - contention	name|mode	master object #	0	Other
enq: MS - contention	name|mode	master object #	0	Other
wait for kkpo ref-partitioning *TEST EVENT*	where			Other
PX slave connection				Other
PX slave release				Other
PX Send Wait				Other
PX qref latch	function	sleeptime	qref	Other
PX server shutdown	nalive	sleeptime	loop	Other
PX create server	nservers	sleeptime	enqueue	Other
PX signal server	serial	error	nbusy	Other
PX Deq Credit: free buffer	sleeptime/senderid	passes	qref	Other
PX Deq: Test for msg	sleeptime/senderid	passes		Other
PX Deq: Test for credit	sleeptime/senderid	passes		Other
PX Deq: Signal ACK RSG	sleeptime/senderid	passes		Other
PX Deq: Signal ACK EXT	sleeptime/senderid	passes		Other
PX Deq: reap credit				Other
PX Nsq: PQ descriptor query				Other
PX Nsq: PQ load info query				Other
PX Deq Credit: Session Stats	sleeptime/senderid	passes		Other
PX Deq: Slave Session Stats	sleeptime/senderid	passes		Other
PX Deq: Slave Join Frag	sleeptime/senderid	passes		Other
enq: PI - contention	name|mode	operation	serial #	Other
enq: PS - contention	name|mode	instance	slave ID	Other
latch: parallel query alloc buffer	address	number	tries	Other
kxfxse	kxfxse debug wait: stalling for slave 0			Other
kxfxsp	kxfxsp debug wait: stalling for slave 0			Other
PX Deq: Table Q qref	sleeptime/senderid	passes		Other
PX Deq: Table Q Get Keys	sleeptime/senderid	passes		Other
PX Deq: Table Q Close	sleeptime/senderid	passes		Other
GV$: slave acquisition retry wait time				Other
PX hash elem being inserted	hashid	element	insert/update	Other
latch: PX hash array latch	address	number	tries	Other
enq: AY - contention	name|mode	Op1	Op2	Other
enq: TO - contention	name|mode	object #	1	Other
enq: IT - contention	name|mode	object #	0	Other
enq: BF - allocation contention	name|mode	node#/parallelizer#	bloom#	Other
enq: BF - PMON Join Filter cleanup	name|mode	node#/parallelizer#	bloom#	Other
enq: RD - RAC load	name|mode	sqlid	execid	Other
kupp process wait				Other
Kupp process shutdown	nalive	sleeptime	loop	Other
Data Pump slave startup				Other
Data Pump slave init				Other
enq: KP - contention	name|mode	0	0	Other
Replication Dequeue	sleeptime/senderid	passes		Other
knpc_acwm_AwaitChangedWaterMark				Other
knpc_anq_AwaitNonemptyQueue				Other
knpsmai				Other
enq: SR - contention	name|mode	operation	sequence # / apply #	Other
Streams capture: waiting for database startup				Other
Streams miscellaneous event	TYPE			Other
enq: SI - contention	name|mode	object #	0	Other
Streams: RAC waiting for inter instance ack				Other
enq: IA - contention	name|mode	0	0	Other
enq: JI - contention	name|mode	view object #	0	Other
qerex_gdml				Other
enq: AT - contention	name|mode	0	0	Other
opishd				Other
kpodplck wait before retrying ORA-54				Other
enq: CQ - contention	name|mode	0	0	Other
Streams AQ: emn coordinator waiting for slave to start				Other
wait for EMON to spawn				Other
EMON termination				Other
EMON slave messages				Other
enq: SE - contention	name|mode	Session-id	Serial#	Other
tsm with timeout				Other
Streams AQ: waiting for busy instance for instance_name	where	wait_count		Other
enq: TQ - TM contention	name|mode	QT_OBJ#	0	Other
enq: TQ - DDL contention	name|mode	QT_OBJ#	0	Other
enq: TQ - INI contention	name|mode	QT_OBJ#	0	Other
enq: TQ - DDL-INI contention	name|mode	QT_OBJ#	0	Other
AQ propagation connection				Other
enq: DP - contention	name|mode	0	0	Other
enq: MH - contention	name|mode	0	0	Other
enq: ML - contention	name|mode	0	0	Other
enq: PH - contention	name|mode	0	0	Other
enq: SF - contention	name|mode	0	0	Other
enq: XH - contention	name|mode	0	0	Other
enq: WA - contention	name|mode	0	0	Other
Streams AQ: QueueTable kgl locks				Other
AQ spill debug idle				Other
queue slave messages				Other
Streams AQ: qmn coordinator waiting for slave to start				Other
XDB SGA initialization				Other
enq: XC - XDB Configuration	name|mode			Other
NFS read delegation outstanding	delegation count			Other
Data Guard Broker Wait	Broker Component	Wait Argument 1	Wait Argument 2	Other
enq: RF - synch: DG Broker metadata	name|mode	lock operation	lock value	Other
enq: RF - atomicity	name|mode	lock operation	lock value	Other
enq: RF - synchronization: aifo master	name|mode	lock operation	lock value	Other
enq: RF - new AI	name|mode	lock operation	lock value	Other
enq: RF - synchronization: critical ai	name|mode	lock operation	lock value	Other
enq: RF - RF - Database Automatic Disable	name|mode	lock operation	lock value	Other
enq: RF - FSFO Observer Heartbeat	name|mode	lock operation	lock value	Other
enq: RF - DG Broker Current File ID	name|mode	lock operation	lock value	Other
PX Deq: OLAP Update Reply	sleeptime/senderid	passes		Other
PX Deq: OLAP Update Execute	sleeptime/senderid	passes		Other
PX Deq: OLAP Update Close	sleeptime/senderid	passes		Other
OLAP Parallel Type Deq	sleeptime/senderid	passes		Other
OLAP Parallel Temp Grow Request	sleeptime/senderid	passes		Other
OLAP Parallel Temp Grow Wait	sleeptime/senderid	passes		Other
OLAP Parallel Temp Grew	sleeptime/senderid	passes		Other
OLAP Null PQ Reason	sleeptime/senderid	passes		Other
OLAP Aggregate Master Enq	sleeptime/senderid	passes		Other
OLAP Aggregate Client Enq	sleeptime/senderid	passes		Other
OLAP Aggregate Master Deq	sleeptime/senderid	passes		Other
OLAP Aggregate Client Deq	sleeptime/senderid	passes		Other
enq: AW - AW$ table lock	name|mode	operation	workspace #	Other
enq: AW - AW state lock	name|mode	operation	workspace #	Other
enq: AW - user access for AW	name|mode	operation	workspace #	Other
enq: AW - AW generation lock	name|mode	operation	workspace #	Other
enq: AG - contention	name|mode	workspace #	generation	Other
enq: AO - contention	name|mode	workspace #	object #	Other
enq: OQ - xsoqhiAlloc	name|mode	resource id	0	Other
enq: OQ - xsoqhiFlush	name|mode	resource id	0	Other
enq: OQ - xsoq*histrecb	name|mode	resource id	0	Other
enq: OQ - xsoqhiClose	name|mode	resource id	0	Other
enq: OQ - xsoqhistrecb	name|mode	resource id	0	Other
enq: AM - client registration	name|mode	id1	id2	Other
enq: AM - shutdown	name|mode	id1	id2	Other
enq: AM - rollback COD reservation	name|mode	id1	id2	Other
enq: AM - background COD reservation	name|mode	id1	id2	Other
enq: AM - ASM cache freeze	name|mode	id1	id2	Other
enq: AM - ASM ACD Relocation	name|mode	id1	id2	Other
enq: AM - group use	name|mode	id1	id2	Other
enq: AM - group block	name|mode	id1	id2	Other
enq: AM - ASM File Destroy	name|mode	id1	id2	Other
enq: AM - ASM User	name|mode	id1	id2	Other
enq: AM - ASM Password File Update	name|mode	id1	id2	Other
enq: AM - ASM Amdu Dump	name|mode	id1	id2	Other
enq: AM - disk offline	name|mode	id1	id2	Other
enq: AM - PST split check	name|mode	id1	id2	Other
ASM internal hang test	test #			Other
ASM Instance startup				Other
buffer busy	group#	obj#	block#	Other
buffer freelistbusy	group#	obj#	block#	Other
buffer rememberlist busy	group#	obj#	block#	Other
buffer writeList full	group#	obj#	block#	Other
no free buffers	group#	obj#	block#	Other
buffer write wait	group#	obj#	block#	Other
buffer invalidation wait	group#	obj#	block#	Other
buffer dirty disabled	group#			Other
ASM metadata cache frozen	group#			Other
enq: CM - gate	name|mode	disk group #	type	Other
enq: CM - instance	name|mode	disk group #	type	Other
enq: XQ - recovery	name|mode	disk group #	unused	Other
enq: XQ - relocation	name|mode	disk group #	unused	Other
enq: XQ - purification	name|mode	disk group #	unused	Other
enq: AD - allocate AU	name|mode	group and disk number	AU number	Other
enq: AD - deallocate AU	name|mode	group and disk number	AU number	Other
enq: AD - relocate AU	name|mode	group and disk number	AU number	Other
enq: DO - disk online	name|mode	disk group #	disk #	Other
enq: DO - disk online recovery	name|mode	disk group #	disk #	Other
enq: DO - Staleness Registry create	name|mode	disk group #	disk #	Other
enq: DO - startup of MARK process	name|mode	disk group #	disk #	Other
enq: DO - disk online operation	name|mode	disk group #	disk #	Other
extent map load/unlock	group	file	extent	Other
enq: XL - fault extent map	name|mode	map id	nothing	Other
Sync ASM rebalance				Other
enq: DG - contention	name|mode	disk group	type	Other
enq: DD - contention	name|mode	disk group	type	Other
enq: HD - contention	name|mode	disk group	0	Other
enq: DN - contention	name|mode	0	0	Other
Cluster stabilization wait				Other
Cluster Suspension wait				Other
ASM background starting				Other
ASM db client exists				Other
ASM file metadata operation	msgop	locn		Other
ASM network foreground exits	group#			Other
enq: FA - access file	name|mode	disk group number	file number	Other
enq: RX - relocate extent	name|mode	disk group #:file #	virtual extent number	Other
log write(odd)	group#			Other
log write(even)	group#			Other
checkpoint advanced	group#			Other
enq: FR - contention	name|mode	disk group	thread	Other
enq: FR - use the thread	name|mode	disk group	thread	Other
enq: FR - recover the thread	name|mode	disk group	thread	Other
enq: FG - serialize ACD relocate	name|mode	disk group	type	Other
enq: FG - FG redo generation enq race	name|mode	disk group	type	Other
enq: FG - LGWR redo generation enq race	name|mode	disk group	type	Other
enq: FT - allow LGWR writes	name|mode	disk group	thread	Other
enq: FT - disable LGWR writes	name|mode	disk group	thread	Other
enq: FC - open an ACD thread	name|mode	disk group	thread	Other
enq: FC - recover an ACD thread	name|mode	disk group	thread	Other
enq: FX - issue ACD Xtnt Relocation CIC	name|mode	disk group	unused	Other
rollback operations block full	max operations			Other
rollback operations active	operation count			Other
enq: RB - contention	name|mode	disk group	0	Other
ASM: MARK subscribe to msg channel				Other
enq: PT - contention	name|mode	disk group #	type	Other
global cache busy	group	file#	block#	Other
lock release pending	group	file#	block#	Other
dma prepare busy	group	obj#	block#	Other
GCS lock cancel	le			Other
GCS lock open S	group	obj#	block#	Other
GCS lock open X	group	obj#	block#	Other
GCS lock open	group	obj#	block#	Other
GCS lock cvt S	group	obj#	block#	Other
GCS lock cvt X	group	obj#	block#	Other
GCS lock esc X	group	obj#	block#	Other
GCS lock esc	group	obj#	block#	Other
GCS recovery lock open	group	obj#	block#	Other
GCS recovery lock convert	group	obj#	block#	Other
kfcl: instance recovery	group	obj#	block#	Other
no free locks				Other
lock close	group	lms#		Other
enq: KQ - access ASM attribute	name|mode	group	entry	Other
ASM Volume Background				Other
ASM DG Unblock				Other
enq: AV - persistent DG number	name|mode	persistent DG number	non-DG number enqs	Other
enq: AV - volume relocate	name|mode	persistent DG number	non-DG number enqs	Other
enq: AV - AVD client registration	name|mode	persistent DG number	non-DG number enqs	Other
enq: AV - add/enable first volume in DG	name|mode	persistent DG number	non-DG number enqs	Other
ASM: OFS Cluster membership update				Other
enq: WF - contention	name|mode	0	0	Other
enq: WP - contention	name|mode	0	0	Other
enq: FU - contention	name|mode	0	0	Other
enq: MW - contention	name|mode	Schedule Id	0	Other
AWR Flush				Other
AWR Metric Capture				Other
enq: TB - SQL Tuning Base Cache Update	name|mode	1	2	Other
enq: TB - SQL Tuning Base Cache Load	name|mode	1	2	Other
enq: SH - contention	name|mode	0	0	Other
enq: AF - task serialization	name|mode	task id	0	Other
MMON slave messages				Other
MMON (Lite) shutdown	process#	waited		Other
enq: MO - contention	name|mode	0	0	Other
enq: TL - contention	name|mode	0	0	Other
enq: TH - metric threshold evaluation	name|mode	0	0	Other
enq: TK - Auto Task Serialization	name|mode	0-MMON, 1-MMON Slave	0	Other
enq: TK - Auto Task Slave Lockout	name|mode	0-MMON, 1-MMON Slave	0	Other
enq: RR - contention	name|mode	lock#	not used	Other
WCR: RAC message context busy				Other
WCR: capture file IO write				Other
WCR: Sync context busy				Other
latch: WCR: sync	address	number	tries	Other
latch: WCR: processes HT	address	number	tries	Other
enq: JS - contention	name|mode	service ID	queue type	Other
enq: JS - job run lock - synchronize	name|mode	service ID	queue type	Other
enq: JS - job recov lock	name|mode	service ID	queue type	Other
enq: JS - queue lock	name|mode	service ID	queue type	Other
enq: JS - sch locl enqs	name|mode	service ID	queue type	Other
enq: JS - q mem clnup lck	name|mode	service ID	queue type	Other
enq: JS - evtsub add	name|mode	service ID	queue type	Other
enq: JS - evtsub drop	name|mode	service ID	queue type	Other
enq: JS - wdw op	name|mode	service ID	queue type	Other
enq: JS - evt notify	name|mode	service ID	queue type	Other
enq: JS - aq sync	name|mode	service ID	queue type	Other
enq: XD - ASM disk drop/add	name|mode	opcode	notused	Other
cell worker online completion	cellhash#			Other
cell worker retry	cellhash#			Other
cell manager cancel work request				Other
secondary event	event #	wait time		Other
LogMiner builder: memory	Session ID			Queueing
LogMiner builder: DDL	Session ID			Queueing
LogMiner preparer: memory	Session ID			Queueing
LogMiner reader: buffer	Session ID			Queueing
Streams capture: waiting for subscribers to catch up				Queueing
Streams: resolve low memory condition				Queueing
Streams: flow control				Queueing
Streams AQ: enqueue blocked on low memory				Queueing
Streams AQ: enqueue blocked due to flow control				Queueing
resmgr:cpu quantum	location			Scheduler
resmgr:large I/O queued	location			Scheduler
resmgr:small I/O queued	location			Scheduler
resmgr:become active	location			Scheduler
enq: JX - SQL statement queue	name|mode	sqlid	execid	Scheduler
enq: JX - cleanup of queue	name|mode	sqlid	execid	Scheduler
PX Queuing: statement queue	sleeptime	passes		Scheduler
Log archive I/O	count	intr	timeout	System I/O
RMAN backup & recovery I/O	count	intr	timeout	System I/O
Standby redo I/O	count	intr	timeout	System I/O
Network file transfer	count	intr	timeout	System I/O
io done	msg ptr			System I/O
RMAN Disk slave I/O	wait count	wait flags	timeout	System I/O
RMAN Tape slave I/O	tape operation	operation flags	timeout	System I/O
DBWR slave I/O	wait count	wait flags	timeout	System I/O
LGWR slave I/O	wait count	wait flags	timeout	System I/O
Archiver slave I/O	wait count	wait flags	timeout	System I/O
control file sequential read	file#	block#	blocks	System I/O
control file single write	file#	block#	blocks	System I/O
control file parallel write	files	block#	requests	System I/O
recovery read				System I/O
RFS sequential i/o				System I/O
RFS random i/o				System I/O
RFS write				System I/O
log file sequential read	log#	block#	blocks	System I/O
log file single write	log#	block#	blocks	System I/O
log file parallel write	files	blocks	requests	System I/O
db file parallel write	requests	interrupt	timeout	System I/O
db file async I/O submit	requests	interrupt	timeout	System I/O
flashback log file write	log#	block#	Bytes	System I/O
flashback log file read	log#	block#	Bytes	System I/O
cell smart incremental backup	cellhash#			System I/O
cell smart restore from backup	cellhash#			System I/O
kfk: async disk IO	count	intr	timeout	System I/O
cell manager opening cell	cellhash#			System I/O
cell manager closing cell	cellhash#			System I/O
cell manager discovering disks	cellhash#			System I/O
Parameter File I/O	blkno	#blks	read/write	User I/O
Disk file operations I/O	FileOperation	fileno	filetype	User I/O
Disk file I/O Calibration	count			User I/O
Disk file Mirror Read	fileno	blkno	filetype	User I/O
Disk file Mirror/Media Repair Write	fileno	blkno	filetype	User I/O
direct path sync	File number	Flags		User I/O
Datapump dump file I/O	count	intr	timeout	User I/O
dbms_file_transfer I/O	count	intr	timeout	User I/O
DG Broker configuration file I/O	count	intr	timeout	User I/O
Data file init write	count	intr	timeout	User I/O
Log file init write	count	intr	timeout	User I/O
Shared IO Pool IO Completion				User I/O
local write wait	file#	block#		User I/O
buffer read retry	file#	block#		User I/O
read by other session	file#	block#	class#	User I/O
db flash cache single block physical read				User I/O
db flash cache multiblock physical read				User I/O
db flash cache write				User I/O
db file sequential read	file#	block#	blocks	User I/O
db file scattered read	file#	block#	blocks	User I/O
db file single write	file#	block#	blocks	User I/O
db file parallel read	files	blocks	requests	User I/O
direct path read	file number	first dba	block cnt	User I/O
direct path read temp	file number	first dba	block cnt	User I/O
direct path write	file number	first dba	block cnt	User I/O
direct path write temp	file number	first dba	block cnt	User I/O
flashback log file sync				User I/O
cell smart table scan	cellhash#			User I/O
cell smart index scan	cellhash#			User I/O
cell statistics gather	cellhash#			User I/O
cell smart file creation	cellhash#			User I/O
Archive Manager file transfer I/O	count	intr	timeout	User I/O
securefile direct-read completion				User I/O
securefile direct-write completion				User I/O
BFILE read				User I/O
utl_file I/O				User I/O
external table read	filectx	file#	size	User I/O
external table write	filectx	file#	size	User I/O
external table misc IO	filectx	iocode	P3	User I/O
dbverify reads	count	intr	timeout	User I/O
ASM Fixed Package I/O	blkno	bytes	filetype	User I/O
ASM Staleness File I/O	blkno	#blks	diskno	User I/O
cell single block physical read	cellhash#	diskhash#	bytes	User I/O
cell multiblock physical read	cellhash#	diskhash#	bytes	User I/O
cell list of blocks physical read	cellhash#	diskhash#	blocks	User I/O