Oracle Wait 확인 방법

아래의 SQL을 통해 조회가 가능하다.


SELECT NAME,
       WAIT_CLASS
FROM   V$EVENT_NAME
ORDER BY WAIT_CLASS,
         NAME
;

목차(10.2.0.3 기준)

Count	Name	Wait Class
1	ASM COD rollback operation completion	Administrative
2	ASM mount : wait for heartbeat	Administrative
3	Backup: sbtbackup	Administrative
4	Backup: sbtclose	Administrative
5	Backup: sbtclose2	Administrative
6	Backup: sbtcommand	Administrative
7	Backup: sbtend	Administrative
8	Backup: sbterror	Administrative
9	Backup: sbtinfo	Administrative
10	Backup: sbtinfo2	Administrative
11	Backup: sbtinit	Administrative
12	Backup: sbtinit2	Administrative
13	Backup: sbtopen	Administrative
14	Backup: sbtpcbackup	Administrative
15	Backup: sbtpccancel	Administrative
16	Backup: sbtpccommit	Administrative
17	Backup: sbtpcend	Administrative
18	Backup: sbtpcquerybackup	Administrative
19	Backup: sbtpcqueryrestore	Administrative
20	Backup: sbtpcrestore	Administrative
21	Backup: sbtpcstart	Administrative
22	Backup: sbtpcstatus	Administrative
23	Backup: sbtpcvalidate	Administrative
24	Backup: sbtread	Administrative
25	Backup: sbtread2	Administrative
26	Backup: sbtremove	Administrative
27	Backup: sbtremove2	Administrative
28	Backup: sbtrestore	Administrative
29	Backup: sbtwrite	Administrative
30	Backup: sbtwrite2	Administrative
31	JS coord start wait	Administrative
32	JS kgl get object wait	Administrative
33	JS kill job wait	Administrative
34	alter rbs offline	Administrative
35	alter system set dispatcher	Administrative
36	buffer pool resize	Administrative
37	enq: DB - contention	Administrative
38	enq: TW - contention	Administrative
39	enq: ZG - contention	Administrative
40	index (re)build online cleanup	Administrative
41	index (re)build online merge	Administrative
42	index (re)build online start	Administrative
43	multiple dbwriter suspend/resume for file offline	Administrative
44	switch logfile command	Administrative
45	switch undo - offline	Administrative
46	wait for possible quiesce finish	Administrative
47	SQL*Net break/reset to client	Application
48	SQL*Net break/reset to dblink	Application
49	Streams capture: filter callback waiting for ruleset	Application
50	Streams: apply reader waiting for DDL to apply	Application
51	Wait for Table Lock	Application
52	enq: KO - fast object checkpoint	Application
53	enq: PW - flush prewarm buffers	Application
54	enq: RO - contention	Application
55	enq: RO - fast object reuse	Application
56	enq: TM - contention	Application
57	enq: TX - row lock contention	Application
58	enq: UL - contention	Application
59	ASM PST query : wait for PM grp 0 grant	Cluster
60	Streams: RAC waiting for inter instance ack	Cluster
61	gc assume	Cluster
62	gc block recovery request	Cluster
63	gc buffer busy	Cluster
64	gc claim	Cluster
65	gc cr block 2-way	Cluster
66	gc cr block 3-way	Cluster
67	gc cr block busy	Cluster
68	gc cr block congested	Cluster
69	gc cr block lost	Cluster
70	gc cr block unknown	Cluster
71	gc cr cancel	Cluster
72	gc cr disk read	Cluster
73	gc cr disk request	Cluster
74	gc cr failure	Cluster
75	gc cr grant 2-way	Cluster
76	gc cr grant busy	Cluster
77	gc cr grant congested	Cluster
78	gc cr grant unknown	Cluster
79	gc cr multi block request	Cluster
80	gc cr request	Cluster
81	gc current block 2-way	Cluster
82	gc current block 3-way	Cluster
83	gc current block busy	Cluster
84	gc current block congested	Cluster
85	gc current block lost	Cluster
86	gc current block unknown	Cluster
87	gc current cancel	Cluster
88	gc current grant 2-way	Cluster
89	gc current grant busy	Cluster
90	gc current grant congested	Cluster
91	gc current grant unknown	Cluster
92	gc current multi block request	Cluster
93	gc current request	Cluster
94	gc current retry	Cluster
95	gc current split	Cluster
96	gc domain validation	Cluster
97	gc freelist	Cluster
98	gc prepare	Cluster
99	gc quiesce wait	Cluster
100	gc recovery free	Cluster
101	gc recovery quiesce	Cluster
102	gc remaster	Cluster
103	lock remastering	Cluster
104	pi renounce write complete	Cluster
105	retry contact SCN lock master	Cluster
106	log file sync	Commit
107	buffer busy waits	Concurrency
108	cursor: mutex S	Concurrency
109	cursor: mutex X	Concurrency
110	cursor: pin S wait on X	Concurrency
111	enq: TX - index contention	Concurrency
112	latch: In memory undo latch	Concurrency
113	latch: MQL Tracking Latch	Concurrency
114	latch: Undo Hint Latch	Concurrency
115	latch: cache buffers chains	Concurrency
116	latch: library cache	Concurrency
117	latch: library cache lock	Concurrency
118	latch: library cache pin	Concurrency
119	latch: row cache objects	Concurrency
120	latch: shared pool	Concurrency
121	library cache load lock	Concurrency
122	library cache lock	Concurrency
123	library cache pin	Concurrency
124	logout restrictor	Concurrency
125	os thread startup	Concurrency
126	pipe put	Concurrency
127	resmgr:internal state change	Concurrency
128	resmgr:internal state cleanup	Concurrency
129	resmgr:sessions to exit	Concurrency
130	row cache lock	Concurrency
131	row cache read	Concurrency
132	Streams AQ: enqueue blocked on low memory	Configuration
133	Streams capture: resolve low memory condition	Configuration
134	Streams capture: waiting for subscribers to catch up	Configuration
135	checkpoint completed	Configuration
136	enq: HW - contention	Configuration
137	enq: SQ - contention	Configuration
138	enq: SS - contention	Configuration
139	enq: ST - contention	Configuration
140	enq: TX - allocate ITL entry	Configuration
141	free buffer waits	Configuration
142	latch: redo copy	Configuration
143	latch: redo writing	Configuration
144	log buffer space	Configuration
145	log file switch (archiving needed)	Configuration
146	log file switch (checkpoint incomplete)	Configuration
147	log file switch (private strand flush incomplete)	Configuration
148	log file switch completion	Configuration
149	sort segment request	Configuration
150	statement suspended, wait error to be cleared	Configuration
151	undo segment extension	Configuration
152	undo segment tx slot	Configuration
153	wait for EMON to process ntfns	Configuration
154	write complete waits	Configuration
155	ASM background timer	Idle
156	DIAG idle wait	Idle
157	EMON idle wait	Idle
158	HS message to agent	Idle
159	JS external job	Idle
160	KSV master wait	Idle
161	LNS ASYNC archive log	Idle
162	LNS ASYNC dest activation	Idle
163	LNS ASYNC end of log	Idle
164	LogMiner: client waiting for transaction	Idle
165	LogMiner: slave waiting for activate message	Idle
166	LogMiner: wakeup event for builder	Idle
167	LogMiner: wakeup event for preparer	Idle
168	LogMiner: wakeup event for reader	Idle
169	PL/SQL lock timer	Idle
170	PX Deq Credit: need buffer	Idle
171	PX Deq: Execute Reply	Idle
172	PX Deq: Execution Msg	Idle
173	PX Deq: Index Merge Close	Idle
174	PX Deq: Index Merge Execute	Idle
175	PX Deq: Index Merge Reply	Idle
176	PX Deq: Join ACK	Idle
177	PX Deq: Msg Fragment	Idle
178	PX Deq: Par Recov Change Vector	Idle
179	PX Deq: Par Recov Execute	Idle
180	PX Deq: Par Recov Reply	Idle
181	PX Deq: Parse Reply	Idle
182	PX Deq: Table Q Normal	Idle
183	PX Deq: Table Q Sample	Idle
184	PX Deq: Txn Recovery Reply	Idle
185	PX Deq: Txn Recovery Start	Idle
186	PX Deq: kdcph_mai	Idle
187	PX Deq: kdcphc_ack	Idle
188	PX Deque wait	Idle
189	PX Idle Wait	Idle
190	SGA: MMAN sleep for component shrink	Idle
191	SQL*Net message from client	Idle
192	SQL*Net message from dblink	Idle
193	Streams AQ: RAC qmn coordinator idle wait	Idle
194	Streams AQ: deallocate messages from Streams Pool	Idle
195	Streams AQ: delete acknowledged messages	Idle
196	Streams AQ: qmn coordinator idle wait	Idle
197	Streams AQ: qmn slave idle wait	Idle
198	Streams AQ: waiting for messages in the queue	Idle
199	Streams AQ: waiting for time management or cleanup tasks	Idle
200	Streams fetch slave: waiting for txns	Idle
201	class slave wait	Idle
202	dispatcher timer	Idle
203	gcs remote message	Idle
204	ges remote message	Idle
205	i/o slave wait	Idle
206	jobq slave wait	Idle
207	parallel recovery coordinator waits for cleanup of slaves	Idle
208	pipe get	Idle
209	pmon timer	Idle
210	rdbms ipc message	Idle
211	single-task message	Idle
212	smon timer	Idle
213	virtual circuit status	Idle
214	wait for unread message on broadcast channel	Idle
215	wait for unread message on multiple broadcast channels	Idle
216	watchdog main loop	Idle
217	ARCH wait for flow-control	Network
218	ARCH wait for net re-connect	Network
219	ARCH wait for netserver detach	Network
220	ARCH wait for netserver init 1	Network
221	ARCH wait for netserver init 2	Network
222	ARCH wait for netserver start	Network
223	ARCH wait on ATTACH	Network
224	ARCH wait on DETACH	Network
225	ARCH wait on SENDREQ	Network
226	LGWR wait on ATTACH	Network
227	LGWR wait on DETACH	Network
228	LGWR wait on LNS	Network
229	LGWR wait on SENDREQ	Network
230	LNS wait on ATTACH	Network
231	LNS wait on DETACH	Network
232	LNS wait on LGWR	Network
233	LNS wait on SENDREQ	Network
234	SQL*Net message to client	Network
235	SQL*Net message to dblink	Network
236	SQL*Net more data from client	Network
237	SQL*Net more data from dblink	Network
238	SQL*Net more data to client	Network
239	SQL*Net more data to dblink	Network
240	TCP Socket (KGAS)	Network
241	TEXT: URL_DATASTORE network wait	Network
242	dedicated server timer	Network
243	dispatcher listen timer	Network
244	ARCH wait for archivelog lock	Other
245	ARCH wait for process death 1	Other
246	ARCH wait for process death 2	Other
247	ARCH wait for process death 3	Other
248	ARCH wait for process death 4	Other
249	ARCH wait for process death 5	Other
250	ARCH wait for process start 1	Other
251	ARCH wait for process start 2	Other
252	ARCH wait for process start 3	Other
253	ARCH wait for process start 4	Other
254	ARCH wait on c/f tx acquire 1	Other
255	ARCH wait on c/f tx acquire 2	Other
256	ASM background running	Other
257	ASM background starting	Other
258	ASM db client exists	Other
259	ASM internal hang test	Other
260	AWR Flush	Other
261	AWR Metric Capture	Other
262	BFILE check if exists	Other
263	BFILE check if open	Other
264	BFILE closure	Other
265	BFILE get length	Other
266	BFILE get name object	Other
267	BFILE get path object	Other
268	BFILE internal seek	Other
269	BFILE open	Other
270	CGS skgxn join retry	Other
271	CGS wait for IPC msg	Other
272	Cluster Suspension wait	Other
273	Cluster stablization wait	Other
274	DBFG waiting for reply	Other
275	DBMS_LDAP: LDAP operation	Other
276	DFS db file lock	Other
277	DFS lock handle	Other
278	Data Guard broker: single instance	Other
279	Data Guard broker: wait upon ORA-12850 error	Other
280	Data Guard: process clean up	Other
281	Data Guard: process exit	Other
282	FAL archive wait 1 sec for REOPEN minimum	Other
283	GCS lock cancel	Other
284	GCS lock cvt S	Other
285	GCS lock cvt X	Other
286	GCS lock esc	Other
287	GCS lock esc X	Other
288	GCS lock open	Other
289	GCS lock open S	Other
290	GCS lock open X	Other
291	GCS recovery lock convert	Other
292	GCS recovery lock open	Other
293	GV$: slave acquisition retry wait time	Other
294	IPC busy async request	Other
295	IPC send completion sync	Other
296	IPC wait for name service busy	Other
297	IPC waiting for OSD resources	Other
298	KJC: Wait for msg sends to complete	Other
299	Kupp process shutdown	Other
300	L1 validation	Other
301	LGWR simulation latency wait	Other
302	LGWR wait for redo copy	Other
303	LGWR wait on full LNS buffer	Other
304	LGWR-LNS wait on channel	Other
305	LMON global data update	Other
306	LNS simulation latency wait	Other
307	LNS wait for LGWR redo	Other
308	Logical Standby Apply shutdown	Other
309	Logical Standby Terminal Apply	Other
310	Logical Standby dictionary build	Other
311	Logical Standby pin transaction	Other
312	MMON (Lite) shutdown	Other
313	MMON slave messages	Other
314	MRP wait on archivelog archival	Other
315	MRP wait on archivelog arrival	Other
316	MRP wait on archivelog delay	Other
317	MRP wait on process death	Other
318	MRP wait on process restart	Other
319	MRP wait on process start	Other
320	MRP wait on startup clear	Other
321	MRP wait on state change	Other
322	MRP wait on state n_a	Other
323	MRP wait on state reset	Other
324	OLAP Aggregate Client Deq	Other
325	OLAP Aggregate Client Enq	Other
326	OLAP Aggregate Master Deq	Other
327	OLAP Aggregate Master Enq	Other
328	OLAP Null PQ Reason	Other
329	OLAP Parallel Temp Grew	Other
330	OLAP Parallel Temp Grow Request	Other
331	OLAP Parallel Temp Grow Wait	Other
332	OLAP Parallel Type Deq	Other
333	PMON to cleanup pseudo-branches at svc stop time	Other
334	PX Deq Credit: free buffer	Other
335	PX Deq Credit: send blkd	Other
336	PX Deq: OLAP Update Close	Other
337	PX Deq: OLAP Update Execute	Other
338	PX Deq: OLAP Update Reply	Other
339	PX Deq: Signal ACK	Other
340	PX Deq: Table Q Close	Other
341	PX Deq: Table Q Get Keys	Other
342	PX Deq: Table Q qref	Other
343	PX Deq: Test for msg	Other
344	PX Deq: reap credit	Other
345	PX Nsq: PQ descriptor query	Other
346	PX Nsq: PQ load info query	Other
347	PX Send Wait	Other
348	PX create server	Other
349	PX qref latch	Other
350	PX server shutdown	Other
351	PX signal server	Other
352	PX slave connection	Other
353	PX slave release	Other
354	RF - FSFO Wait for Ack	Other
355	RFS announce	Other
356	RFS attach	Other
357	RFS close	Other
358	RFS create	Other
359	RFS detach	Other
360	RFS dispatch	Other
361	RFS ping	Other
362	RFS register	Other
363	RVWR wait for flashback copy	Other
364	Replication Dequeue	Other
365	SGA: allocation forcing component growth	Other
366	SGA: sga_target resize	Other
367	Streams AQ: enqueue blocked due to flow control	Other
368	Streams AQ: qmn coordinator waiting for slave to start	Other
369	Streams AQ: waiting for busy instance for instance_name	Other
370	Streams capture: waiting for archive log	Other
371	Streams capture: waiting for database startup	Other
372	Sync ASM rebalance	Other
373	Wait for TT enqueue	Other
374	Wait for shrink lock	Other
375	Wait for shrink lock2	Other
376	Wait on stby instance close	Other
377	affinity expansion in replay	Other
378	block change tracking buffer space	Other
379	buffer busy	Other
380	buffer deadlock	Other
381	buffer dirty disabled	Other
382	buffer exterminate	Other
383	buffer freelistbusy	Other
384	buffer invalidation wait	Other
385	buffer latch	Other
386	buffer rememberlist busy	Other
387	buffer resize	Other
388	buffer write wait	Other
389	buffer writeList full	Other
390	change tracking file parallel write	Other
391	change tracking file synchronous read	Other
392	change tracking file synchronous write	Other
393	check CPU wait times	Other
394	checkpoint advanced	Other
395	cleanup of aborted process	Other
396	control file diagnostic dump	Other
397	control file heartbeat	Other
398	cr request retry	Other
399	cursor: pin S	Other
400	cursor: pin X	Other
401	debugger command	Other
402	dispatcher shutdown	Other
403	dma prepare busy	Other
404	dupl. cluster key	Other
405	enq: AD - allocate AU	Other
406	enq: AD - deallocate AU	Other
407	enq: AF - task serialization	Other
408	enq: AG - contention	Other
409	enq: AM - client registration	Other
410	enq: AM - rollback COD reservation	Other
411	enq: AM - shutdown	Other
412	enq: AO - contention	Other
413	enq: AS - modify service	Other
414	enq: AS - service activation	Other
415	enq: AT - contention	Other
416	enq: AU - audit index file	Other
417	enq: AW - AW generation lock	Other
418	enq: AW - AW state lock	Other
419	enq: AW - AW$ table lock	Other
420	enq: AW - user access for AW	Other
421	enq: BF - allocation contention	Other
422	enq: BR - file shrink	Other
423	enq: BR - proxy-copy	Other
424	enq: CF - contention	Other
425	enq: CI - contention	Other
426	enq: CL - compare labels	Other
427	enq: CL - drop label	Other
428	enq: CM - gate	Other
429	enq: CM - instance	Other
430	enq: CN - race with init	Other
431	enq: CN - race with reg	Other
432	enq: CN - race with txn	Other
433	enq: CT - CTWR process start/stop	Other
434	enq: CT - change stream ownership	Other
435	enq: CT - global space management	Other
436	enq: CT - local space management	Other
437	enq: CT - reading	Other
438	enq: CT - state	Other
439	enq: CT - state change gate 1	Other
440	enq: CT - state change gate 2	Other
441	enq: CU - contention	Other
442	enq: DD - contention	Other
443	enq: DF - contention	Other
444	enq: DG - contention	Other
445	enq: DL - contention	Other
446	enq: DM - contention	Other
447	enq: DN - contention	Other
448	enq: DP - contention	Other
449	enq: DR - contention	Other
450	enq: DS - contention	Other
451	enq: DT - contention	Other
452	enq: DV - contention	Other
453	enq: DX - contention	Other
454	enq: FA - access file	Other
455	enq: FB - contention	Other
456	enq: FC - open an ACD thread	Other
457	enq: FC - recover an ACD thread	Other
458	enq: FD - Flashback coordinator	Other
459	enq: FD - Flashback on/off	Other
460	enq: FD - Marker generation	Other
461	enq: FD - Restore point create/drop	Other
462	enq: FD - Tablespace flashback on/off	Other
463	enq: FG - FG redo generation enq race	Other
464	enq: FG - LGWR redo generation enq race	Other
465	enq: FG - serialize ACD relocate	Other
466	enq: FL - Flashback database log	Other
467	enq: FL - Flashback db command	Other
468	enq: FM - contention	Other
469	enq: FP - global fob contention	Other
470	enq: FR - contention	Other
471	enq: FS - contention	Other
472	enq: FT - allow LGWR writes	Other
473	enq: FT - disable LGWR writes	Other
474	enq: FU - contention	Other
475	enq: HD - contention	Other
476	enq: HP - contention	Other
477	enq: HQ - contention	Other
478	enq: HV - contention	Other
479	enq: IA - contention	Other
480	enq: ID - contention	Other
481	enq: IL - contention	Other
482	enq: IM - contention for blr	Other
483	enq: IR - contention	Other
484	enq: IR - contention2	Other
485	enq: IS - contention	Other
486	enq: IT - contention	Other
487	enq: JD - contention	Other
488	enq: JI - contention	Other
489	enq: JQ - contention	Other
490	enq: JS - contention	Other
491	enq: JS - evt notify	Other
492	enq: JS - evtsub add	Other
493	enq: JS - evtsub drop	Other
494	enq: JS - job recov lock	Other
495	enq: JS - job run lock - synchronize	Other
496	enq: JS - q mem clnup lck	Other
497	enq: JS - queue lock	Other
498	enq: JS - sch locl enqs	Other
499	enq: JS - wdw op	Other
500	enq: KK - context	Other
501	enq: KM - contention	Other
502	enq: KP - contention	Other
503	enq: KT - contention	Other
504	enq: MD - contention	Other
505	enq: MH - contention	Other
506	enq: MK - contention	Other
507	enq: ML - contention	Other
508	enq: MN - contention	Other
509	enq: MR - contention	Other
510	enq: MS - contention	Other
511	enq: MW - contention	Other
512	enq: OC - contention	Other
513	enq: OL - contention	Other
514	enq: OQ - xsoq*histrecb	Other
515	enq: OQ - xsoqhiAlloc	Other
516	enq: OQ - xsoqhiClose	Other
517	enq: OQ - xsoqhiFlush	Other
518	enq: OQ - xsoqhistrecb	Other
519	enq: OW - initialization	Other
520	enq: OW - termination	Other
521	enq: PD - contention	Other
522	enq: PE - contention	Other
523	enq: PF - contention	Other
524	enq: PG - contention	Other
525	enq: PH - contention	Other
526	enq: PI - contention	Other
527	enq: PL - contention	Other
528	enq: PR - contention	Other
529	enq: PS - contention	Other
530	enq: PT - contention	Other
531	enq: PV - syncshut	Other
532	enq: PV - syncstart	Other
533	enq: PW - perwarm status in dbw0	Other
534	enq: RB - contention	Other
535	enq: RF - RF - Database Automatic Disable	Other
536	enq: RF - RF - FSFO Observed	Other
537	enq: RF - RF - FSFO connectivity	Other
538	enq: RF - RF - FSFO state	Other
539	enq: RF - RF - FSFO synchronization	Other
540	enq: RF - RF - FSFO wait	Other
541	enq: RF - atomicity	Other
542	enq: RF - new AI	Other
543	enq: RF - synch: DG Broker metadata	Other
544	enq: RF - synchronization: HC master	Other
545	enq: RF - synchronization: aifo master	Other
546	enq: RF - synchronization: chief	Other
547	enq: RF - synchronization: critical ai	Other
548	enq: RN - contention	Other
549	enq: RP - contention	Other
550	enq: RS - file delete	Other
551	enq: RS - persist alert level	Other
552	enq: RS - prevent aging list update	Other
553	enq: RS - prevent file delete	Other
554	enq: RS - read alert level	Other
555	enq: RS - record reuse	Other
556	enq: RS - write alert level	Other
557	enq: RT - contention	Other
558	enq: RU - contention	Other
559	enq: RU - waiting	Other
560	enq: RW - MV metadata contention	Other
561	enq: SB - contention	Other
562	enq: SE - contention	Other
563	enq: SF - contention	Other
564	enq: SH - contention	Other
565	enq: SI - contention	Other
566	enq: SK - contention	Other
567	enq: SR - contention	Other
568	enq: SU - contention	Other
569	enq: SW - contention	Other
570	enq: TA - contention	Other
571	enq: TB - SQL Tuning Base Cache Load	Other
572	enq: TB - SQL Tuning Base Cache Update	Other
573	enq: TC - contention	Other
574	enq: TC - contention2	Other
575	enq: TD - KTF dump entries	Other
576	enq: TE - KTF broadcast	Other
577	enq: TF - contention	Other
578	enq: TL - contention	Other
579	enq: TO - contention	Other
580	enq: TQ - DDL contention	Other
581	enq: TQ - INI contention	Other
582	enq: TQ - TM contention	Other
583	enq: TS - contention	Other
584	enq: TT - contention	Other
585	enq: TX - contention	Other
586	enq: US - contention	Other
587	enq: WA - contention	Other
588	enq: WF - contention	Other
589	enq: WL - contention	Other
590	enq: WP - contention	Other
591	enq: WR - contention	Other
592	enq: XH - contention	Other
593	enq: XQ - recovery	Other
594	enq: XQ - relocation	Other
595	enq: XR - database force logging	Other
596	enq: XR - quiesce database	Other
597	enq: XY - contention	Other
598	events in waitclass Other	Other
599	extent map load/unlock	Other
600	flashback buf free by RVWR	Other
601	flashback free VI log	Other
602	flashback log switch	Other
603	free global transaction table entry	Other
604	free process state object	Other
605	gcs ddet enter server mode	Other
606	gcs domain validation	Other
607	gcs drm freeze begin	Other
608	gcs drm freeze in enter server mode	Other
609	gcs enter server mode	Other
610	gcs log flush sync	Other
611	gcs remastering wait for read latch	Other
612	gcs remastering wait for write latch	Other
613	gcs resource directory to be unfrozen	Other
614	gcs to be enabled	Other
615	ges LMD suspend for testing event	Other
616	ges LMD to inherit communication channels	Other
617	ges LMD to shutdown	Other
618	ges LMON for send queues	Other
619	ges LMON to get to FTDONE	Other
620	ges LMON to join CGS group	Other
621	ges cached resource cleanup	Other
622	ges cancel	Other
623	ges cgs registration	Other
624	ges enter server mode	Other
625	ges generic event	Other
626	ges global resource directory to be frozen	Other
627	ges inquiry response	Other
628	ges lmd and pmon to attach	Other
629	ges lmd/lmses to freeze in rcfg - mrcvr	Other
630	ges lmd/lmses to unfreeze in rcfg - mrcvr	Other
631	ges master to get established for SCN op	Other
632	ges performance test completion	Other
633	ges pmon to exit	Other
634	ges process with outstanding i/o	Other
635	ges reconfiguration to start	Other
636	ges resource cleanout during enqueue open	Other
637	ges resource cleanout during enqueue open-cvt	Other
638	ges resource directory to be unfrozen	Other
639	ges retry query node	Other
640	ges reusing os pid	Other
641	ges user error	Other
642	ges wait for lmon to be ready	Other
643	ges1 LMON to wake up LMD - mrcvr	Other
644	ges2 LMON to wake up LMD - mrcvr	Other
645	ges2 LMON to wake up lms - mrcvr 2	Other
646	ges2 LMON to wake up lms - mrcvr 3	Other
647	ges2 proc latch in rm latch get 1	Other
648	ges2 proc latch in rm latch get 2	Other
649	global cache busy	Other
650	global enqueue expand wait	Other
651	imm op	Other
652	inactive session	Other
653	inactive transaction branch	Other
654	index block split	Other
655	instance state change	Other
656	job scheduler coordinator slave wait	Other
657	jobq slave TJ process wait	Other
658	jobq slave shutdown wait	Other
659	kcbzps	Other
660	kcrrrcp	Other
661	kdic_do_merge	Other
662	kfcl: instance recovery	Other
663	kgltwait	Other
664	kjbdomalc allocate recovery domain - retry	Other
665	kjbdrmcvtq lmon drm quiesce: ping completion	Other
666	kjbopen wait for recovery domain attach	Other
667	kjctcisnd: Queue/Send client message	Other
668	kjctssqmg: quick message send wait	Other
669	kjudomatt wait for recovery domain attach	Other
670	kjudomdet wait for recovery domain detach	Other
671	kjxgrtest	Other
672	kkdlgon	Other
673	kkdlhpon	Other
674	kkdlsipon	Other
675	kksfbc child completion	Other
676	kksfbc research	Other
677	kkshgnc reloop	Other
678	kksscl hash split	Other
679	knpc_acwm_AwaitChangedWaterMark	Other
680	knpc_anq_AwaitNonemptyQueue	Other
681	knpsmai	Other
682	ksbcic	Other
683	ksbsrv	Other
684	ksdxexeother	Other
685	ksdxexeotherwait	Other
686	ksim generic wait event	Other
687	ksqded	Other
688	ksv slave avail wait	Other
689	ksxr poll remote instances	Other
690	ksxr wait for mount shared	Other
691	ktfbtgex	Other
692	ktm: instance recovery	Other
693	ktsambl	Other
694	kttm2d	Other
695	kupp process wait	Other
696	kxfxse	Other
697	kxfxsp	Other
698	latch activity	Other
699	latch free	Other
700	latch: Change Notification Hash table latch	Other
701	latch: KCL gc element parent latch	Other
702	latch: cache buffer handles	Other
703	latch: cache buffers lru chain	Other
704	latch: checkpoint queue latch	Other
705	latch: enqueue hash chains	Other
706	latch: gcs resource hash	Other
707	latch: ges resource hash list	Other
708	latch: messages	Other
709	latch: object queue header heap	Other
710	latch: object queue header operation	Other
711	latch: parallel query alloc buffer	Other
712	latch: redo allocation	Other
713	latch: session allocation	Other
714	latch: undo global data	Other
715	latch: virtual circuit queues	Other
716	library cache revalidation	Other
717	library cache shutdown	Other
718	listen endpoint status	Other
719	lms flush message acks	Other
720	lock close	Other
721	lock deadlock retry	Other
722	lock escalate retry	Other
723	lock release pending	Other
724	log file switch (clearing log file)	Other
725	log switch/archive	Other
726	log write(even)	Other
727	log write(odd)	Other
728	master exit	Other
729	name-service call wait	Other
730	no free buffers	Other
731	no free locks	Other
732	null event	Other
733	opishd	Other
734	optimizer stats update retry	Other
735	pending global transaction(s)	Other
736	prewarm transfer retry	Other
737	prior spawner clean up	Other
738	process shutdown	Other
739	process startup	Other
740	process terminate	Other
741	qerex_gdml	Other
742	queue slave messages	Other
743	rdbms ipc message block	Other
744	rdbms ipc reply	Other
745	recovery area: computing applied logs	Other
746	recovery area: computing backed up files	Other
747	recovery area: computing dropped files	Other
748	recovery area: computing identical files	Other
749	recovery area: computing obsolete files	Other
750	reliable message	Other
751	rfi_drcx_site_del	Other
752	rfi_insv_shut	Other
753	rfi_insv_start	Other
754	rfi_nsv_deldef	Other
755	rfi_nsv_md_close	Other
756	rfi_nsv_md_write	Other
757	rfi_nsv_postdef	Other
758	rfi_nsv_shut	Other
759	rfi_nsv_start	Other
760	rfi_recon1	Other
761	rfi_recon2	Other
762	rfm_dmon_last_gasp	Other
763	rfm_dmon_pdefer	Other
764	rfm_dmon_shut	Other
765	rfm_dmon_timeout_op	Other
766	rfm_pmon_dso_stall	Other
767	rfrdb_dbop	Other
768	rfrdb_recon1	Other
769	rfrdb_recon2	Other
770	rfrdb_try235	Other
771	rfrla_lapp1	Other
772	rfrla_lapp2	Other
773	rfrla_lapp3	Other
774	rfrla_lapp4	Other
775	rfrla_lapp5	Other
776	rfrld_rhmrpwait	Other
777	rfrm_dbcl	Other
778	rfrm_dbop	Other
779	rfrm_nonzero_sub_count	Other
780	rfrm_rsm_shut	Other
781	rfrm_rsm_so_attach	Other
782	rfrm_rsm_start	Other
783	rfrm_stall	Other
784	rfrm_zero_sub_count	Other
785	rfrpa_mrpdn	Other
786	rfrpa_mrpup	Other
787	rfrxpt_pdl	Other
788	rfrxptarcurlog	Other
789	rollback operations active	Other
790	rollback operations block full	Other
791	rolling migration: cluster quiesce	Other
792	scginq AST call	Other
793	secondary event	Other
794	select wait	Other
795	set director factor wait	Other
796	simulated log write delay	Other
797	slave exit	Other
798	test long ops	Other
799	timer in sksawat	Other
800	transaction	Other
801	tsm with timeout	Other
802	txn to complete	Other
803	unbound tx	Other
804	undo segment recovery	Other
805	undo_retention publish retry	Other
806	unspecified wait event	Other
807	wait active processes	Other
808	wait for EMON to die	Other
809	wait for EMON to spawn	Other
810	wait for FMON to come up	Other
811	wait for MTTR advisory state object	Other
812	wait for a paralle reco to abort	Other
813	wait for a undo record	Other
814	wait for another txn - rollback to savepoint	Other
815	wait for another txn - txn abort	Other
816	wait for another txn - undo rcv abort	Other
817	wait for assert messages to be sent	Other
818	wait for change	Other
819	wait for master scn	Other
820	wait for membership synchronization	Other
821	wait for message ack	Other
822	wait for record update	Other
823	wait for rr lock release	Other
824	wait for scn ack	Other
825	wait for split-brain resolution	Other
826	wait for stopper event to be increased	Other
827	wait for sync ack	Other
828	wait for tmc2 to complete	Other
829	wait for verification ack	Other
830	wait for votes	Other
831	wait list latch activity	Other
832	wait list latch free	Other
833	waiting to get CAS latch	Other
834	waiting to get RM CAS latch	Other
835	writes stopped by instance recovery or database suspension	Other
836	resmgr:become active	Scheduler
837	resmgr:cpu quantum	Scheduler
838	ARCH random i/o	System I/O
839	ARCH sequential i/o	System I/O
840	ARCH wait for pending I/Os	System I/O
841	LGWR random i/o	System I/O
842	LGWR sequential i/o	System I/O
843	LNS ASYNC control file txn	System I/O
844	Log archive I/O	System I/O
845	RFS random i/o	System I/O
846	RFS sequential i/o	System I/O
847	RFS write	System I/O
848	RMAN backup & recovery I/O	System I/O
849	Standby redo I/O	System I/O
850	control file parallel write	System I/O
851	control file sequential read	System I/O
852	control file single write	System I/O
853	db file parallel write	System I/O
854	io done	System I/O
855	kfk: async disk IO	System I/O
856	ksfd: async disk IO	System I/O
857	kst: async disk IO	System I/O
858	log file parallel write	System I/O
859	log file sequential read	System I/O
860	log file single write	System I/O
861	recovery read	System I/O
862	BFILE read	User I/O
863	DG Broker configuration file I/O	User I/O
864	Data file init write	User I/O
865	Datapump dump file I/O	User I/O
866	Log file init write	User I/O
867	buffer read retry	User I/O
868	db file parallel read	User I/O
869	db file scattered read	User I/O
870	db file sequential read	User I/O
871	db file single write	User I/O
872	dbms_file_transfer I/O	User I/O
873	direct path read	User I/O
874	direct path read temp	User I/O
875	direct path write	User I/O
876	direct path write temp	User I/O
877	local write wait	User I/O
878	read by other session	User I/O

latch: cache buffer handles

OWI(Oracle Wait Interface) (by xsoft) [2009.10.21]

Oracle Wait 확인 방법

목차(10.2.0.3 기준)

latch: cache buffer handles