在v$session_wait_history中根据事件分组统计后的信息是这样的。
1 SQL*Net message from client 17203
2 log file sync 218
3 Streams AQ: waiting for messages in the queue 6
4 enq: DX - contention 2
5 log file switch completion 1
6 enq: TX - row lock contention 2
7 wait for unread message on broadcast channel 10
8 os thread startup 1
9 control file parallel write 3
10 LGWR-LNS wait on channel 8
11 latch: shared pool 41
12 control file sequential read 42
13 log file switch (checkpoint incomplete) 5
14 SQL*Net break/reset to client 4
15 SQL*Net more data to client 380
16 latch: cache buffers chains 473
17 db file sequential read 21
18 jobq slave wait 20
19 buffer busy waits 2
20 LNS wait on SENDREQ 6
21 rdbms ipc message 92
22 smon timer 2
23 SQL*Net more data from client 150
24 direct path write 12
25 latch: session allocation 5
26 latch free 894
27 direct path sync 14
28 latch: library cache lock 5
29 Streams AQ: qmn slave idle wait 10
30 enq: HW - contention 1
31 SQL*Net message to client 16464
32 log file parallel write 1
33 direct path read 34
34 latch: library cache 25
35 Streams AQ: waiting for time management or cleanup tasks 10
36 Streams AQ: qmn coordinator idle wait 10
37 rdbms ipc reply 8
38 LNS wait on LGWR 5