index fast full scans (full) index fetch by key index scans kdiixs1 leaf node 90-10 splits leaf node splits lob reads lob writes lob writes unaligned local undo segment hints helped local undo segment hints were stale logons cumulative messages received messages sent no buffer to keep pinned count no work - consistent read gets opened cursors cumulative parse count (failures) parse count (hard) parse count (total) parse time cpu parse time elapsed physical read IO requests physical read bytes physical read total IO requests physical read total bytes physical read total multi block requests physical reads physical reads cache physical reads cache prefetch physical reads direct physical reads direct temporary tablespace physical reads prefetch warmup physical write IO requests physical write bytes physical write total IO requests physical write total bytes physical write total multi block requests physical writes physical writes direct physical writes direct (lob) physical writes direct temporary tablespace physical writes from cache physical writes non checkpoint pinned buffers inspected prefetch clients - default prefetch warmup blocks aged out before use prefetch warmup blocks flushed out before use prefetched blocks aged out before use process last non-idle time queries parallelized 13 852,181 339,583 34 106,552 11 83 83 0 0 61 20,040 19,880 0 1,513,070 183,375 1 143 182,780 27 338 82,815 2,643,378,176 98,871 2,905,491,456 24,089 322,678 213,728 191,830 108,950 108,812 0 223,456 133,835 116,135 1,714,120 1,276,780 0 108,812 437,340 1,673,703 10 0 0 0 0 4,730 16 0.00 180.26 71.83 0.01 22.54 0.00 0.02 0.02 0.00 0.00 0.01 4.24 4.21 0.00 320.06 38.79 0.00 0.03 38.66 0.01 0.07 17.52 559,161.45 20.91 614,607.04 5.10 68.26 45.21 40.58 23.05 23.02 0.00 47.27 28.31 24.57 362.59 270.08 0.00 23.02 92.51 354.04 0.00 0.00 0.00 0.00 0.00 1.00 0.00 0.00 152.23 60.66 0.01 19.03 0.00 0.01 0.01 0.00 0.00 0.01 3.58 3.55 0.00 270.29 32.76 0.00 0.03 32.65 0.00 0.06 14.79 472,200.46 17.66 519,023.13 4.30 57.64 38.18 34.27 19.46 19.44 0.00 39.92 23.91 20.75 306.20 228.08 0.00 19.44 78.12 298.98 0.00 0.00 0.00 0.00 0.00 0.84 0.00 14,042,071,040 2,970,360.02 2,508,408.55 23,114,268,672 4,889,428.30 4,129,022.63 recursive calls recursive cpu usage redo blocks written redo buffer allocation retries redo entries redo log space requests redo log space wait time redo ordering marks redo size redo subscn max counts redo synch time redo synch writes redo wastage redo write time redo writer latching time redo writes rollback changes - undo records applied rollbacks only - consistent read gets rows fetched via callback session connect time session cursor cache hits session logical reads session pga memory session pga memory max session uga memory session uga memory max shared hash latch upgrades - no wait shared hash latch upgrades - wait sorts (disk) sorts (memory) sorts (rows) space was found by tune down space was not found by tune down sql area evicted sql area purged steps of tune down ret. in space pressure summed dirty queue length switch current to new buffer table fetch by rowid table fetch continued row table scan blocks gotten table scan rows gotten table scans (long tables) table scans (short tables) total number of times SMON posted transaction lock background get time transaction lock background gets transaction lock foreground requests transaction lock foreground wait time transaction rollbacks 1,654,650 2,641 8,766,094 24 4,707,068 34 50 277,042 4,343,559,400 2,693 408 6,984 1,969,620 5,090 1 5,494 166,609 1,463 342,159 1,461 180,472 16,648,792 37,393,448 45,192,232 61,930,448 6,364 0 4 2,857 42,379,505 0 0 7 44 0 35,067 17 680,469 0 790,986 52,989,363 4 169,201 259 0 0 0 0 294 350.01 0.56 1,854.32 0.01 995.70 0.01 0.01 58.60 918,805.72 0.57 0.09 1.48 416.64 1.08 0.00 1.16 35.24 0.31 72.38 0.31 38.18 3,521.77 7,909.94 9,559.64 13,100.33 1.35 0.00 0.00 0.60 8,964.66 0.00 0.00 0.00 0.01 0.00 7.42 0.00 143.94 0.00 167.32 11,208.99 0.00 35.79 0.05 0.00 0.00 0.00 0.00 0.06 295.58 0.47 1,565.93 0.00 840.85 0.01 0.01 49.49 775,912.72 0.48 0.07 1.25 351.84 0.91 0.00 0.98 29.76 0.26 61.12 0.26 32.24 2,974.06 6,679.79 8,072.92 11,062.96 1.14 0.00 0.00 0.51 7,570.47 0.00 0.00 0.00 0.01 0.00 6.26 0.00 121.56 0.00 141.30 9,465.77 0.00 30.23 0.05 0.00 0.00 0.00 0.00 0.05 30,067,312,240 6,360,225.77 5,371,081.14 tune down retentions in space pressure undo change vector size user I/O wait time user calls user commits user rollbacks workarea executions - onepass workarea executions - optimal write clones created in background write clones created in foreground Back to Instance Activity Statistics Back to Top
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