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

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 …… 此处隐藏：2664字，全部文档内容请下载后查看。喜欢就下载吧 ……