PHP Code:wakeup time manager 2 0 527 ###### 0.0
jobq slave wait 173 170 500 2891 0.0
SQL*Net message to client 2,188,933 0 4 0 95.6
SQL*Net more data from clien 5 0 0 17 0.0
-------------------------------------------------------------
Background Wait Events DB/Inst: ORAPERF/oraperf Snaps: 720-721
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
db file parallel write 47,954 0 946 20 2.1
log file parallel write 43,225 0 177 4 1.9
Queue Monitor Task Wait 2 0 10 4883 0.0
control file parallel write 234 0 6 24 0.0
control file sequential read 90 0 1 7 0.0
process startup 8 0 0 53 0.0
db file sequential read 98 0 0 2 0.0
control file single write 18 0 0 9 0.0
db file scattered read 17 0 0 5 0.0
rdbms ipc reply 121 0 0 1 0.0
LGWR wait for redo copy 949 0 0 0 0.0
latch: cache buffers chains 4 4 0 5 0.0
latch: redo allocation 4 0 0 0 0.0
latch: cache buffers lru cha 4 0 0 0 0.0
buffer busy waits 2 0 0 0 0.0
rdbms ipc message 23,385 2,612 6,292 269 1.0
smon timer 54 0 635 11762 0.0
Queue Monitor Wait 18 18 527 29297 0.0
-------------------------------------------------------------
Wait Event Histogram DB/Inst: ORAPERF/oraperf Snaps: 720-721
-> ordered by event (idle events last)
Event
--------------------------------------------------
0 - 1 ms 1 - 4 ms 4 - 8 ms 8 - 16 ms 16 - 32 ms 32+ ms
------------ ------------ ------------ ------------ ------------ ------------
LGWR wait for redo copy
944 3 0 0 0 0
Queue Monitor Task Wait
0 0 0 0 0 2
SQL*Net break/reset to client
95,954 1,202 16 3 0 0
SQL*Net more data to client
198 0 0 0 0 0
buffer busy waits
6,969 30 17 19 5 5
buffer deadlock
165 0 0 0 0 0
class slave wait
0 0 0 0 0 2
control file parallel write
0 0 0 16 212 2
control file sequential read
611 813 864 34 1 0
control file single write
0 0 6 11 0 0
db file parallel write
7,356 4,102 6,199 11,964 10,434 7,895
db file scattered read
3 6 13 0 0 0
db file sequential read
10,503 258,045 761,357 279,182 101,814 80,164
enq: HW - contention
3 1 0 0 0 0
enq: SQ - contention
2 2 0 0 0 0
enq: TX - index contention
909 140 104 67 43 30
enq: TX - row lock contention
0 0 0 0 0 1
latch free
141 9 0 54 0 0
latch: In memory undo latch
3 0 0 0 0 0
latch: cache buffers chains
809 0 0 223 0 0
latch: cache buffers lru chain
3 0 0 0 0 0
latch: enqueue hash chains
1 0 0 0 0 0
latch: library cache
126 69 27 2 0 0
latch: library cache pin
19 8 0 0 0 0
latch: redo allocation
4 1 0 0 0 0
latch: row cache objects
2 5 0 0 0 0
latch: shared pool
Wait Event Histogram DB/Inst: ORAPERF/oraperf Snaps: 720-721
-> ordered by event (idle events last)
Reply With Quote