| Wait Event | Waits | Timeouts | Time Waited | Average Wait |
|---|---|---|---|---|
| rdbms ipc message | 1349601 | 1036179 | 337987779 | 250.44 |
| SQL*Net message from client | 962451 | 0 | 125381810 | 130.27 |
| wait for unread message on broadcast channel | 417281 | 321744 | 31750850 | 76.09 |
| jobq slave wait | 107506 | 102280 | 31481270 | 292.83 |
| Streams AQ: qmn slave idle wait | 22690 | 5 | 31451625 | 1386.14 |
| pmon timer | 108721 | 108712 | 31440977 | 289.19 |
| Streams AQ: waiting for messages in the queue | 66574 | 64292 | 31436176 | 472.2 |
| dispatcher timer | 906625 | 449732 | 31420133 | 34.66 |
| Streams AQ: qmn coordinator idle wait | 34543 | 12088 | 31359464 | 907.84 |
| Streams AQ: waiting for time management or cleanup tasks | 13822 | 8214 | 30923344 | 2237.26 |
| smon timer | 2103 | 696 | 30425416 | 14467.63 |
| virtual circuit status | 419802 | 2100 | 26471826 | 63.06 |
| control file parallel write | 112003 | 0 | 63020 | .56 |
| log file parallel write | 328799 | 0 | 53810 | .16 |
| TCP Socket (KGAS) | 1447 | 0 | 50166 | 34.67 |
| db file sequential read | 147251 | 0 | 30904 | .21 |
| log file sync | 219573 | 1101 | 28768 | .13 |
| SQL*Net break/reset to client | 28730 | 0 | 21289 | .74 |
| SQL*Net more data to client | 25669 | 0 | 18809 | .73 |
| RMAN backup & recovery I/O | 15018 | 0 | 8031 | .53 |
| db file scattered read | 10651 | 0 | 6687 | .63 |
| os thread startup | 2487 | 0 | 5158 | 2.07 |
| SQL*Net more data from client | 5672 | 0 | 4354 | .77 |
| pipe get | 426 | 0 | 4225 | 9.92 |
| PL/SQL lock timer | 265 | 265 | 2882 | 10.88 |
| Streams AQ: qmn coordinator waiting for slave to start | 7 | 5 | 2443 | 348.93 |
| Datapump dump file I/O | 46337 | 0 | 1591 | .03 |
| Log archive I/O | 3335 | 0 | 925 | .28 |
| switch logfile command | 14 | 0 | 876 | 62.58 |
| log file switch completion | 174 | 0 | 860 | 4.94 |
| control file sequential read | 395256 | 0 | 723 | 0 |
| enq: UL - contention | 8 | 0 | 623 | 77.83 |
| enq: CF - contention | 23 | 0 | 569 | 24.73 |
| enq: RO - fast object reuse | 590 | 0 | 503 | .85 |
| control file heartbeat | 1 | 1 | 391 | 390.69 |
| enq: KO - fast object checkpoint | 758 | 0 | 391 | .52 |
| rdbms ipc reply | 767 | 0 | 278 | .36 |
| reliable message | 789 | 1 | 189 | .24 |
| SQL*Net message to client | 964531 | 0 | 188 | 0 |
| local write wait | 1014 | 0 | 177 | .17 |
| latch free | 262 | 0 | 171 | .65 |
| log file sequential read | 3595 | 0 | 163 | .05 |
| latch: shared pool | 155 | 50 | 126 | .82 |
| log file switch (checkpoint incomplete) | 3 | 1 | 117 | 39.09 |
| enq: TC - contention | 3 | 0 | 104 | 34.51 |
| library cache lock | 7 | 0 | 72 | 10.26 |
| kupp process wait | 5 | 5 | 50 | 9.93 |
| write complete waits | 44 | 2 | 50 | 1.15 |
| LGWR wait for redo copy | 6110 | 0 | 41 | .01 |
| SGA: MMAN sleep for component shrink | 44 | 35 | 41 | .92 |
| enq: WL - contention | 1 | 0 | 34 | 33.64 |
| Data file init write | 186 | 0 | 25 | .13 |
| direct path read | 124731 | 0 | 25 | 0 |
| log buffer space | 185 | 1 | 20 | .11 |
| SGA: allocation forcing component growth | 19 | 15 | 17 | .92 |
| control file single write | 60 | 0 | 17 | .29 |
| log file single write | 171 | 0 | 15 | .09 |
| latch: library cache | 620 | 0 | 14 | .02 |
| direct path write | 35150 | 0 | 10 | 0 |
| latch: library cache pin | 37 | 0 | 9 | .25 |
| class slave wait | 113 | 0 | 7 | .06 |
| read by other session | 8 | 0 | 7 | .88 |
| db file single write | 122 | 0 | 6 | .05 |
| latch: row cache objects | 42 | 0 | 6 | .13 |
| cursor: pin S wait on X | 6 | 5 | 5 | .9 |
| kksfbc child completion | 1 | 1 | 5 | 4.9 |
| latch: cache buffers chains | 36 | 0 | 5 | .14 |
| latch: session allocation | 17 | 0 | 5 | .32 |
| latch: library cache lock | 17 | 0 | 2 | .09 |
| latch: redo allocation | 59 | 0 | 2 | .04 |
| buffer busy waits | 119 | 0 | 1 | .01 |
| cursor: pin S | 7 | 0 | 1 | .2 |
| direct path write temp | 2124 | 0 | 1 | 0 |
| library cache load lock | 3 | 0 | 1 | .2 |
| cursor: mutex S | 1 | 0 | 0 | 0 |
| direct path read temp | 1864 | 0 | 0 | 0 |
| enq: JS - queue lock | 2 | 0 | 0 | .15 |
| enq: WF - contention | 1 | 0 | 0 | .16 |
| instance state change | 2 | 0 | 0 | .01 |
| latch: In memory undo latch | 20 | 0 | 0 | .01 |
| latch: cache buffers lru chain | 3 | 0 | 0 | 0 |
| latch: enqueue hash chains | 2 | 0 | 0 | .01 |
| latch: messages | 3 | 0 | 0 | 0 |
| latch: object queue header operation | 8 | 0 | 0 | .02 |
| latch: virtual circuit queues | 4 | 0 | 0 | .03 |
| row cache lock | 3 | 0 | 0 | .08 |
| undo segment extension | 854 | 852 | 0 | 0 |