by-nc-sa     개발자, DBA가 함께 만들어가는 구루비 지식창고!

OWI(Oracle Wait Interface)




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

문서정보

Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.