-------------------------------------------- ------------ ----------- --------
CPU
time 361 54.14
log file
sync 74,324 101 15.22 enqueue 729 88 13.28
db file sequential
read 7,303 65 9.76 SQL*Net message from
dblink 482 20 3.05
Wait Events for DB: ORA92 Instance: ora92 Snaps: 13 -14 -> 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
---------------------------- ------------ ---------- ---------- ------ --------
log file
sync 74,324 0 101 1 1.0
enqueue 729 0 88 121 0.0
db file sequential
read 7,303 0 65 9 0.1 SQL*Net message from
dblink 482 0 20 42 0.0 db file parallel
write 725 0 14 19 0.0 db file scattered
read 2,415 0 6 3 0.0 process
startup 8 0 4 440 0.0
latch
free 1,307 1,300 2 1 0.0
log file parallel
write 67,042 0 2 0 0.9 control file sequential
read 269 0 1 3 0.0
single-task
message 24 0 1 33 0.0 control file parallel
write 325 0 1 2 0.0
buffer busy
waits 3,368 0 1 0 0.0 log file switch
completion 19 0 0 20 0.0
direct path
read 288 0 0 0 0.0 LGWR wait for redo
copy 1,032 0 0 0 0.0 SQL*Net more data to
client 1,390 0 0 0 0.0
kksfbc child
completion 1 1 0 10 0.0 log file sequential
read 2 0 0 5 0.0
direct path
write 128 0 0 0 0.0 library cache
pin 14 0 0 0 0.0 SQL*Net more data from
dblin 4 0 0 0 0.0 log file single
write 2 0 0 1 0.0 SQL*Net message to
dblink 482 0 0 0 0.0
buffer
deadlock 30 30 0 0 0.0
SQL*Net message from
client 436,773 0 143,221 328 5.8
jobq slave
wait 2,688 1,664 6,688 2488 0.0 wakeup time
manager 27 27 791 29297 0.0 SQL*Net message to
client 436,772 0 0 0 5.8
Background Wait Events for DB: ORA92 Instance: ora92 Snaps: 13 -14 -> 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 725 0 14 19 0.0 log file parallel
write 67,044 0 2 0 0.9 control file sequential
read 186 0 1 4 0.0 control file parallel
write 325 0 1 2 0.0 db file scattered
read 38 0 0 7 0.0 direct path
read 288 0 0 0 0.0 LGWR wait for redo
copy 1,032 0 0 0 0.0 db file sequential
read 3 0 0 6 0.0 log file sequential
read 2 0 0 5 0.0
相关推荐：
loading