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

0 1,451,085,596 11,992 1,544,383 812 4,786 1 1,616 0 11 0.00 306,952.35 2.54 326.69 0.17 1.01 0.00 0.34 0.00 0.00 0.00 259,215.00 2.14 275.88 0.15 0.85 0.00 0.29 0.00 0.00 Instance Activity Stats - Absolute Values

?

Statistics with absolute values (should not be diffed) Statistic session cursor cache count opened cursors current logons current Back to Instance Activity Statistics Back to Top

Begin Value End Value 3,024 37 24 3,592 39 26 Instance Activity Stats - Thread Activity

?

Statistics identified by '(derived)' come from sources other than SYSSTAT

Total per Hour 9 6.85 Statistic log switches (derived) Back to Instance Activity Statistics Back to Top

IO Stats

? ? Tablespace IO Stats File IO Stats Back to Top

Tablespace IO Stats

?

ordered by IOs (Reads + Writes) desc

Av Reads/s 14 0 3 Av Rd(ms) 3.76 12.00 8.74 Av Blks/Rd Av Writes/s 34 12 1 Buffer Waits 6 625 0 Av Buf Wt(ms) 0.00 0.02 0.00 Tablespace Reads ICCIDAT01 UNDOTBS1 TEMP 67,408 10 15,022 Writes 3.17 160,261 1.00 57,771 7.24 3,831 USERS SYSAUX SYSTEM UNDOTBS2 68 263 32 6 0 0 0 0 5.44 5.48 5.94 16.67 1.00 1.00 1.00 1.00 971 458 158 6 0 0 0 0 0 0 3 0 0.00 0.00 23.33 0.00 显示每个表空间的I/O统计。根据Oracle经验，Av Rd(ms) [Average Reads in milliseconds]不应该超过30，否则认为有I/O争用。

Back to IO Stats Back to Top

File IO Stats

?

ordered by Tablespace, File

Av Reads/s 1 2 1 2 1 1 2 2 1 0 0 0 0 0 0 0 0 0 0 0 1 1 0 2 0 0 0 Av Rd(ms) 4.30 4.12 2.59 2.93 2.61 4.03 4.12 3.83 4.79 5.31 4.45 4.23 5.13 4.91 5.29 7.23 6.26 8.44 5.48 5.94 5.67 4.42 2.50 12.43 12.00 16.67 5.44 Av Blks/Rd Av Writes/s 3 4 3 3 5 4 4 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12 0 0 Buffer Waits 1 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 0 3 0 0 0 0 625 0 0 Av Buf Wt(ms) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 23.33 0.02 0.00 0.00 Tablespace ICCIDAT01 ICCIDAT01 ICCIDAT01 ICCIDAT01 ICCIDAT01 ICCIDAT01 ICCIDAT01 ICCIDAT01 ICCIDAT01 ICCIDAT01 ICCIDAT01 ICCIDAT01 ICCIDAT01 ICCIDAT01 ICCIDAT01 ICCIDAT01 ICCIDAT01 ICCIDAT01 SYSAUX SYSTEM TEMP TEMP TEMP TEMP Filename /dev/rora_icci01 /dev/rora_icci02 /dev/rora_icci03 /dev/rora_icci04 /dev/rora_icci05 /dev/rora_icci06 /dev/rora_icci07 /dev/rora_icci08 /dev/rora_icci09 /dev/rora_icci10 /dev/rora_icci11 /dev/rora_icci12 /dev/rora_icci13 /dev/rora_icci14 /dev/rora_icci15 /dev/rora_icci16 /dev/rora_icci17 /dev/rora_icci18 /dev/rora_SYSAUX /dev/rora_SYSTEM /dev/rora_TEMP /dev/rora_TEMP2 /dev/rora_TEMP3 /dev/rora_TEMP5 Reads 5,919 7,692 6,563 8,076 6,555 6,943 7,929 7,719 6,794 211 1,168 478 355 411 172 119 227 77 263 32 3,653 2,569 1,022 7,778 10 6 68 Writes 3.73 15,161 3.18 16,555 3.80 15,746 3.11 16,164 3.31 21,958 3.41 20,574 2.87 18,263 2.99 17,361 3.29 18,425 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 6.61 6.70 16.86 6.46 6 6 6 6 6 6 6 6 6 458 158 827 556 557 1,891 UNDOTBS1 /dev/rora_UNDO0101 UNDOTBS2 /dev/rora_UNDO0201 USERS /dev/rora_USERS 1.00 57,771 1.00 1.00 6 971 Back to IO Stats Back to Top

Buffer Pool Statistics

? ?

P D Standard block size Pools D: default, K: keep, R: recycle Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

Pool Hit% Buffer Gets Physical Reads 213,729 Physical Writes 437,340 Free Buff Wait 0 Writ Comp Wait 0 Buffer Busy Waits 634 Number of Buffers 401,071 99 15,480,754

Back to Top

Advisory Statistics

? ? ? ? ? ? ? ? ? ? Instance Recovery Stats Buffer Pool Advisory PGA Aggr Summary PGA Aggr Target Stats PGA Aggr Target Histogram PGA Memory Advisory Shared Pool Advisory SGA Target Advisory Streams Pool Advisory Java Pool Advisory Back to Top

Instance Recovery Stats

?

B: Begin snapshot, E: End snapshot

Estd MTTR (s) 0 0 11 98 Actual Redo Blks 2316 1828613 Target Redo Blks 5807 1883700 Log File Size Redo Blks 1883700 1883700 Log Ckpt Timeout Redo Blks 5807 5033355 Log Ckpt Interval Redo Blks B E Targt MTTR (s) Recovery Estd IOs 369 116200 Back to Advisory Statistics Back to Top

Buffer Pool Advisory

? ?

Only rows with estimated physical reads >0 are displayed ordered by Block Size, Buffers For Estimate

P Size for Est (M) Size Factor Buffers for Estimate Est Phys Read Factor Estimated Physical Reads D D D D D D D D D 320 640 960 1,280 1,600 1,920 2,240 2,560 2,880 0.10 0.19 0.29 0.38 0.48 0.57 0.67 0.77 0.86 38,380 76,760 115,140 153,520 191,900 230,280 268,660 307,040 345,420 1.34 1.25 1.08 1.04 1.02 1.01 1.01 1.01 1.01 10,351,726 9,657,000 8,365,242 8,059,415 7,878,202 7,841,140 7,829,141 7,817,370 7,804,884