Oracle - AWR - 教你如何看 - 图文(13)

Requests 14,075 964 24 4,223 10,548 1 121,768 103 9,933 12 18 16 3 3 14 14 2 2 6 Waits 7,033 556 14 37 58 1 70 46 39 12 13 8 3 3 3 1 1 1 2 Undo Statistics

? ? Undo Segment Summary Undo Segment Stats Back to Top

Undo Segment Summary

? ?

Min/Max TR (mins) - Min and Max Tuned Retention (minutes) STO - Snapshot Too Old count, OOS - Out of Space count

? ? ?

Undo TS# 1 Undo segment block stats:

uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed eS - expired Stolen, eR - expired Released, eU - expired reUsed

Max Qry Len (s) 0 Num Undo Blocks (K) 219.12 Number of Transactions 113,405 Max Tx Concurcy Min/Max TR (mins) 6 130.95/239.25 STO/ OOS 0/0 uS/uR/uU/ eS/eR/eU 0/0/0/13/24256/0 Back to Undo Statistics Back to Top

Undo Segment Stats

?

End Time 25-Dec 15:18 25-Dec 15:08 25-Dec 14:58 25-Dec 14:48 25-Dec 14:38 25-Dec 14:28 25-Dec 14:18 25-Dec 14:08 Most recent 35 Undostat rows, ordered by Time desc Num Undo Blocks 182,021 57 68 194 570 36,047 70 91 Number of Transactions 74,309 170 31 4,256 12,299 21,328 907 105 Max Qry Len (s) 0 0 0 0 0 0 0 0 Max Tx Concy 5 3 2 4 5 6 3 3 Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU 0/0/0/13/24256/0 0/0/0/0/0/0 0/0/0/0/0/0 0/0/0/0/0/0 0/0/0/0/0/0 0/0/0/0/0/0 0/0/0/0/0/0 0/0/0/0/0/0 131 0/0 239 0/0 229 0/0 219 0/0 209 0/0 200 0/0 162 0/0 154 0/0 Back to Undo Statistics Back to Top

Latch Statistics

? ? ? ? ? Latch Activity Latch Sleep Breakdown Latch Miss Sources Parent Latch Statistics Child Latch Statistics Back to Top

Latch Activity

? ? ?

\requests

\ \ Latch Name Get Pct Get Avg Slps Wait NoWait Pct NoWait