SID EVENT TOTAL_WAITS TIME_WAITED AVERAGE_WAIT MAX_WAIT ---------- ---------------------------------------------------------------- ----------- ----------- ------------ ---------- 128 SQL*Net message to client 27 0 0 0 128 SQL*Net message from client 26 34375 1322 34228 131 SQL*Net message to client 34 0 0 0 131 SQL*Net message from client 33 143 4 136 133 db file scattered read 1 0 0 0 133 SQL*Net message to client 83 0 0 0 133 db file sequential read 14 3 0 1 133 log file sync 13 4 0 1 133 SQL*Net message from client 82 192976 2353 6999 134 SQL*Net message to client 1543 0 0 0 134 SQL*Net more data from client 3 0 0 0 134 SQL*Net break/reset to client 132 2 0 0 134 log file sync 96 4 0 1 134 db file scattered read 87 37 0 1 134 db file sequential read 118 63 1 1 134 SQL*Net message from client 1542 194131 126 15999 135 SQL*Net message to client 1477 0 0 0 135 SQL*Net more data to client 7 0 0 0 135 reliable message 127 4 0 0 135 db file scattered read 7 6 1 2 SID EVENT TOTAL_WAITS TIME_WAITED AVERAGE_WAIT MAX_WAIT ---------- ---------------------------------------------------------------- ----------- ----------- ------------ ---------- 135 log file sync 177 10 0 1 135 db file sequential read 55 17 0 1 135 SQL*Net message from client 1477 42 0 3 135 queue messages 406 201761 497 513 136 SQL*Net message to client 146 0 0 0 136 log file sync 25 1 0 1 136 SQL*Net break/reset to client 124 2 0 0 136 db file sequential read 10 3 0 1 136 SQL*Net message from client 146 16 0 4 136 wait for unread message on broadcast channel 1915 196611 103 104 137 SQL*Net message to client 2387 0 0 0 137 db file sequential read 7 2 0 1 137 SQL*Net message from client 2386 197406 83 500 140 class slave wait 1 512 512 512 140 wakeup time manager 1 11542 11542 11542 142 SQL*Net message to client 26 0 0 0 142 SQL*Net more data to client 4 0 0 0 142 SQL*Net message from client 26 16788 646 12544 144 rdbms ipc reply 4 0 0 0 144 local write wait 7 0 0 0 144 latch: library cache 3 0 0 0 SID EVENT TOTAL_WAITS TIME_WAITED AVERAGE_WAIT MAX_WAIT ---------- ---------------------------------------------------------------- ----------- ----------- ------------ ---------- 144 enq: RO - fast object reuse 2 0 0 0 144 SQL*Net message to client 16 0 0 0 144 control file sequential read 8 1 0 1 144 log file switch completion 2 18 9 11 144 direct path write temp 48004 26 0 2 144 db file sequential read 288 352 1 52 144 SQL*Net message from client 16 1149 72 1139 144 direct path read temp 9268 2000 0 52 144 db file scattered read 5510 8591 2 54 144 direct path read 18689 20407 1 62 145 SQL*Net message to client 77 0 0 0 145 SQL*Net more data to client 65 0 0 0 145 SQL*Net more data from client 2 0 0 0 145 SQL*Net break/reset to client 2 0 0 0 145 db file sequential read 43 73 2 52 145 SQL*Net message from client 76 68691 904 34344 148 SQL*Net message to client 678 0 0 0 148 SQL*Net break/reset to client 110 2 0 0 148 log file sync 81 6 0 1 148 db file scattered read 42 24 1 2 148 db file sequential read 418 257 1 46 SID EVENT TOTAL_WAITS TIME_WAITED AVERAGE_WAIT MAX_WAIT ---------- ---------------------------------------------------------------- ----------- ----------- ------------ ---------- 148 SQL*Net message from client 677 202930 300 33020 149 log file sync 4 0 0 0 149 SQL*Net message to client 268 0 0 0 149 SQL*Net more data to client 16 0 0 0 149 SQL*Net more data from client 55 0 0 0 149 db file scattered read 9 5 1 1 149 control file sequential read 71 17 0 3 149 db file sequential read 143 59 0 3 149 SQL*Net message from client 267 201840 756 15099 150 SQL*Net message to client 2 0 0 0 150 SQL*Net message from client 1 0 0 0 151 SQL*Net message to client 256 0 0 0 151 SQL*Net more data to client 4 0 0 0 151 db file scattered read 40 27 1 3 151 db file sequential read 292 134 0 39 151 SQL*Net message from client 255 6631 26 1419 153 SQL*Net message to client 76 0 0 0 153 db file scattered read 1 1 1 1 153 db file sequential read 5 2 0 1 153 log file sync 33 5 0 2 153 SQL*Net message from client 75 191986 2560 6000 SID EVENT TOTAL_WAITS TIME_WAITED AVERAGE_WAIT MAX_WAIT ---------- ---------------------------------------------------------------- ----------- ----------- ------------ ---------- 154 db file sequential read 1 1 1 1 154 rdbms ipc message 1982 204567 103 307 156 process startup 2 1 1 1 156 db file scattered read 3 4 1 3 156 control file sequential read 92 28 0 2 156 db file sequential read 317 180 1 7 156 rdbms ipc message 797 204042 256 312 157 SQL*Net message to client 2 0 0 0 157 SQL*Net message from client 1 0 0 0 158 log file sync 1 0 0 0 158 SQL*Net message to client 2 0 0 0 158 SQL*Net message from client 1 2 2 2 158 db file sequential read 24 10 0 1 158 db file scattered read 14 16 1 3 159 process startup 1 0 0 0 159 Queue Monitor Task Wait 69 498 7 498 159 Queue Monitor Wait 66 200785 3042 3074 162 jobq slave wait 5 1538 308 308 163 db file sequential read 22 14 1 4 163 rdbms ipc message 407 205561 505 514 164 db file sequential read 1 23 23 23 SID EVENT TOTAL_WAITS TIME_WAITED AVERAGE_WAIT MAX_WAIT ---------- ---------------------------------------------------------------- ----------- ----------- ------------ ---------- 164 rdbms ipc message 5 190730 38146 184308 165 read by other session 1 0 0 0 165 library cache load lock 3 1 0 1 165 db file scattered read 61 91 1 4 165 db file sequential read 1330 449 0 34 165 smon timer 15 196403 13094 30718 166 process startup 2 0 0 0 166 control file single write 5 0 0 0 166 direct path write 11 0 0 0 166 direct path read 11 1 0 1 166 control file sequential read 30 17 1 2 166 control file parallel write 682 459 1 71 166 rdbms ipc message 684 205126 300 309 167 control file single write 3 0 0 0 167 log file single write 6 0 0 0 167 direct path read temp 1 0 0 0 167 direct path read 11 0 0 0 167 LGWR wait for redo copy 7 0 0 0 167 direct path write 11 0 0 0 167 control file parallel write 17 1 0 0 167 log file sequential read 6 3 0 2 SID EVENT TOTAL_WAITS TIME_WAITED AVERAGE_WAIT MAX_WAIT ---------- ---------------------------------------------------------------- ----------- ----------- ------------ ---------- 167 control file sequential read 45 17 0 4 167 log file parallel write 1605 320 0 37 167 rdbms ipc message 2163 205242 95 310 168 direct path read 11 0 0 0 168 direct path read temp 1 0 0 0 168 control file sequential read 40 2 0 1 168 db file parallel write 943 169 0 22 168 rdbms ipc message 693 205379 296 309 169 rdbms ipc message 670 205574 307 308 134 rows selected