Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | reliable message | 14,816 | 0.99 | 209 | 14 | 0.08 | control file sequential read | 530,831 | 0.00 | 108 | 0 | 2.71 | control file parallel write | 63,634 | 0.00 | 68 | 1 | 0.32 | db file parallel write | 22,192 | 0.00 | 59 | 3 | 0.11 | gc cr block 2-way | 35,411 | 0.00 | 16 | 0 | 0.18 | CGS wait for IPC msg | 1,882,810 | 100.00 | 15 | 0 | 9.61 | log file parallel write | 8,468 | 0.00 | 14 | 2 | 0.04 | enq: WF - contention | 1,510 | 0.26 | 9 | 6 | 0.01 | log file sync | 106 | 0.00 | 7 | 65 | 0.00 | os thread startup | 233 | 0.86 | 7 | 29 | 0.00 | gc current multi block request |
reliable message 这个等待事件,是因为网络原因,还是CRS问题! 那这个等待事件怎么解决呢?
|
|