1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
| TOP 5 DES EVENEMENTS CONSOMMANT DE LA CPU
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
db file sequential read 14,389,603 256,052 59.21
CPU time 123,656 28.59
buffer busy waits 938,262 13,974 3.23
direct path write 24,250 12,014 2.78
async disk IO 1,005,764 7,942 1.84
-------------------------------------------------------------
Wait Events for DB: TEST Instance: TEST Snaps: 51383 -51416
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
db file sequential read 14,389,603 0 256,052 18 79.1
buffer busy waits 938,262 10 13,974 15 5.2
direct path write 24,250 0 12,014 495 0.1
async disk IO 1,005,764 0 7,942 8 5.5
log file sync 199,194 45 5,340 27 1.1
db file scattered read 350,879 0 5,319 15 1.9
log file parallel write 205,177 205,118 3,919 19 1.1
control file parallel write 42,458 0 1,478 35 0.2
db file parallel write 28,839 0 1,185 41 0.2
latch free 288,977 19,215 460 2 1.6
library cache pin 14,834 0 454 31 0.1
control file sequential read 228,503 0 377 2 1.3
direct path read 6,067 0 134 22 0.0
log file sequential read 1,166 0 74 63 0.0
enqueue 135 2 21 153 0.0
SQL*Net more data to client 287,374 0 19 0 1.6
SQL*Net break/reset to clien 12,624 0 13 1 0.1
log file switch completion 34 2 10 282 0.0
local write wait 116 0 4 38 0.0
process startup 102 0 4 41 0.0
db file single write 210 0 3 14 0.0
log file single write 44 0 1 16 0.0
wait list latch free 9 0 0 18 0.0
direct path read (lob) 1 0 0 23 0.0
undo segment extension 23,319 23,319 0 0 0.1
direct path write (lob) 1 0 0 12 0.0
LGWR wait for redo copy 68 0 0 0 0.0
row cache lock 1 0 0 1 0.0
SQL*Net message from client 12,671,864 0 1,479,003 117 69.6
jobq slave wait 2,214 2,130 6,576 2970 0.0
SQL*Net message to client 12,671,869 0 27 0 69.6
SQL*Net more data from clien 20,081 0 4 0 0.1 |
Partager