详细解读 STATSPACK 报告

-------------------------------------------- ------------ ----------- --------

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