|
刚回答完,准备贴一些数据的时候,居然打不开itpub了,现在才ok。
这是数据库最近几个小时的一些统计数据:
Top 5 Timed Events
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
db file sequential read 2,984,430 8,665 3 58.7 User I/O
CPU time 2,424 16.4
db file scattered read 259,943 1,904 7 12.9 User I/O
library cache pin 632 1,441 2,280 9.8 Concurrency
read by other session 63,425 187 3 1.3 User I/O
Wait Events
Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
db file sequential read 2,984,430 0.00 8,665 3 21.68
Buffer Wait Statistics
Class Waits Total Wait Time (s) Avg Time (ms)
data block 42,231 134 3
undo block 21,419 52 2
segment header 730 2 3
file header block 16 1 59
1st level bmb 5,075 0 0
Latch Activity
Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
cache buffers chains 643,734,048 0.37 0.00 0 12,468,065 0.00
Latch Sleep Breakdown
Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 643,734,048 2,390,224 247 2,389,984 0 0 0 |
|