set pagesize 80
select event, total_waits,time_waited
from V$system_event
where event NOT IN
('pmon timer', 'smon timer', 'rdbms ipc reply', 'parallel deque wait',
'virtual circuit', '%SQL*Net%', 'client message', 'NULL event')
order by time_waited desc;
EVENT TOTAL_WAITS TIME_WAITED
---------------------------------------------------------------- ----------- -----------
SQL*Net message from client 2544593029 9.5738E+10
rdbms ipc message 59890948 9356298126
EMON slave idle wait 4176203 2088107168
Space Manager: slave idle wait 5305448 1054797785
DIAG idle wait 8318686 831907680
Streams AQ: emn coordinator idle wait 417631 417636828
Streams AQ: qmn coordinator idle wait 299027 417635512
Streams AQ: qmn slave idle wait 149517 417632391
LNS ASYNC end of log 28649629 412144766
Streams AQ: waiting for time management or cleanup tasks 16 374508583
db file sequential read 6094148284 101288206
db file scattered read 240411748 6836985
db file parallel read 186404095 6398861
direct path read 27329910 3512900
log file parallel write 27909838 2252334
log file sync 23244780 2045899
SQL*Net more data to client 22152314 1597210
SQL*Net more data from client 2966774 1552454
PX Idle Wait 116 1444719
db file parallel write 20117770 1329762
jobq slave wait 22514 1117679
flashback log file write 2382695 750777
control file parallel write 5019598 519358
read by other session 6240301 428481
LNS wait on SENDREQ 26527936 322477
SQL*Net message to client 2544371341 237607
enq: TX - row lock contention 14420 209558
enq: TX - contention 7033 196450
direct path write temp 1151975 188288
control file sequential read 29607742 128987
log file sequential read 301381 112421
db file async I/O submit 5513873 102108
SQL*Net break/reset to client 2106997 81595
wait for unread message on broadcast channel 209565 78040
direct path read temp 1138231 68282
os thread startup 17821 52884
SQL*Net vector data to client 5716120 49388
enq: WF - contention 2 42613
Disk file operations I/O 4605590 39631
cursor: pin S wait on X 323 36576
Log archive I/O 1081 33843
Data file init write 49795 19149
SQL*Net vector data from client 153052 18207
buffer busy waits 1927510 15544
flashback log file read 47424 11843
enq: TX - index contention 15879 7702
recovery area: computing applied logs 246 7652
reliable message 617437 3202
ADR block file read 62178 3046
Parameter File I/O 1392690 3043
enq: KO - fast object checkpoint 5929 2541
JS coord start wait 49 2446
Data Guard Broker Wait 24 2350
cursor: pin S 545364 2151
parallel recovery slave idle wait 251 1322
library cache: mutex X 33616 1304
latch: cache buffers chains 853324 1267
securefile chain update 1274 1197
PX Deq: Txn Recovery Start 50 1186
enq: CF - contention 198 1155
undo segment extension 1573 1033
wait for EMON to spawn 1025 1027
flashback log file sync 4815 1020
direct path write 7287 906
control file single write 3431 833
log file switch completion 148 820
LGWR wait for redo copy 190555 734
local write wait 2042 725
row cache lock 468 635
ADR block file write 11690 573
SecureFile mutex 12300 555
ARCH wait on SENDREQ 410 456
switch logfile command 50 430
library cache lock 58 426
control file heartbeat 1 400
latch free 28211 396
write complete waits 14 346
EVENT TOTAL_WAITS TIME_WAITED
---------------------------------------------------------------- ----------- -----------
class slave wait 17323 275
log file single write 1024 263
ARCH wait for process start 3 3 246
enq: TC - contention 409 241
enq: CR - block range reuse ckpt 766 215
LGWR-LNS wait on channel 148 148
ARCH wait on ATTACH 5 141
db file single write 1264 138
parallel recovery slave wait for change 419 112
log buffer space 2 111
ADR file lock 14058 101
SGA: allocation forcing component growth 6 73
kksfbc child completion 13 65
enq: RO - fast object reuse 203 53
asynch descriptor resize 239660 46
buffer exterminate 44 44
SGA: MMAN sleep for component shrink 112 42
latch: cache buffers lru chain 11299 40
library cache load lock 117 29
latch: shared pool 201 26
wait for stopper event to be increased 12 24
recovery read 95 22
latch: object queue header operation 4066 22
latch: undo global data 6610 20
enq: HW - contention 50 14
buffer deadlock 14213 14
LNS wait on ATTACH 1 12
enq: JS - queue lock 13 11
utl_file I/O 250 5
PX Deque wait 23 4
CSS initialization 1 4
PX Deq: Slave Session Stats 142 4
enq: SQ - contention 91 3
parallel recovery coord wait for reply 115 3
enq: PR - contention 2 3
Streams AQ: emn coordinator waiting for slave to start 5 2
latch: active service list 287 2
log file switch (checkpoint incomplete) 1 2
PX Deq: Join ACK 71 1
Disk file Mirror/Media Repair Write 3 1
latch: call allocation 71 1
PX Deq: Test for credit 18 1
ARCH wait on DETACH 4 1
latch: redo writing 50 1
latch: messages 86 1
latch: redo allocation 75 1
enq: TX - allocate ITL entry 12 1
latch: row cache objects 365 1
Streams AQ: qmn coordinator waiting for slave to start 2 0
enq: RF - synch: DG Broker metadata 137 0
ASM file metadata operation 1 0
enq: PS - contention 1 0
PX Deq: Signal ACK EXT 71 0
PX Deq: Test for msg 301 0
PX Deq Credit: free buffer 41 0
PX qref latch 2 0
instance state change 2 0
enq: FB - contention 1 0
latch: lob segment dispenser latch 7 0
latch: lob segment hash table latch 23 0
enq: US - contention 2 0
parallel recovery coord send blocked 1 0
ARCH wait for archivelog lock 425 0
latch: checkpoint queue latch 35 0
latch: enqueue hash chains 36 0
latch: session allocation 1 0
wait list latch free 3 0
PX Deq Credit: need buffer 2 0
cursor: mutex X 49 0
PX Deq: Txn Recovery Reply 2 0
LNS wait on LGWR 1 0
LNS wait on DETACH 1 0
checkpoint completed 2 0
DG Broker configuration file I/O 13 0
151 rows selected.
SQL>
Comments