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

D D D D D D D D D D D D 3,200 3,344 3,520 3,840 4,160 4,480 4,800 5,120 5,440 5,760 6,080 6,400 0.96 1.00 1.05 1.15 1.24 1.34 1.44 1.53 1.63 1.72 1.82 1.91 383,800 401,071 422,180 460,560 498,940 537,320 575,700 614,080 652,460 690,840 729,220 767,600 1.00 1.00 0.99 0.99 0.99 0.99 0.99 0.98 0.98 0.98 0.98 0.98 7,784,014 7,748,403 7,702,243 7,680,429 7,663,046 7,653,232 7,645,544 7,630,008 7,616,886 7,614,591 7,613,191 7,599,930 Back to Advisory Statistics Back to Top

PGA Aggr Summary

?

PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written 87.91 Back to Advisory Statistics Back to Top

1,100 151 PGA Aggr Target Stats

? ? ? ? ? ?

B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)

Auto PGA Target - actual workarea memory target

W/A PGA Used - amount of memory used for all Workareas (manual + auto) %PGA W/A Mem - percentage of PGA memory allocated to workareas

%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt %Man W/A Mem - percentage of workarea memory under manual control

%Man W/A Mem 0.00 0.00 B E PGA Aggr Target(M) 1,024 1,024 Auto PGA Target(M) 862 860 PGA Mem Alloc(M) 150.36 154.14 W/A PGA Used(M) 0.00 0.00 %PGA %Auto W/A Mem W/A Mem 0.00 0.00 0.00 0.00 Global Mem Bound(K) 104,850 104,850 Back to Advisory Statistics Back to Top

PGA Aggr Target Histogram

?

Optimal Executions are purely in-memory operations

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs 2K 64K 128K 4K 128K 256K 1,385 28 5 1,385 28 5 0 0 0 0 0 0 256K 512K 1M 8M 128M 256M 512K 1024K 2M 16M 256M 512M 79 108 7 1 3 1 79 108 7 1 2 1 0 0 0 0 1 0 0 0 0 0 0 0 Back to Advisory Statistics Back to Top

PGA Memory Advisory

?

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

Size Factr 0.13 0.25 0.50 0.75 1.00 1.20 1.40 1.60 1.80 2.00 3.00 4.00 6.00 8.00 W/A MB Processed 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 4,652.12 Estd Extra W/A MB Read/ Written to Disk 2,895.99 2,857.13 2,857.13 2,857.13 717.82 717.82 717.82 717.82 717.82 717.82 717.82 717.82 717.82 717.82 Estd PGA Cache Hit % 62.00 62.00 62.00 62.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 87.00 Estd PGA Overalloc Count 0 0 0 0 0 0 0 0 0 0 0 0 0 0 PGA Target Est (MB) 128 256 512 768 1,024 1,229 1,434 1,638 1,843 2,048 3,072 4,096 6,144 8,192 Back to Advisory Statistics Back to Top

Shared Pool Advisory

? ?

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor

Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Est LC Size (M) 78 78 78 78 78 78 78 78 Est LC Mem Obj 7,626 7,626 7,626 7,626 7,626 7,626 7,626 7,626 Est LC Time Saved (s) 64,842 64,842 64,842 64,842 64,842 64,842 64,842 64,842 Est LC Time Saved Factr 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Est LC Load Time (s) 31 31 31 31 31 31 31 31 Est LC Est LC Mem Load Time Obj Hits Factr 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 3,206,955 3,206,955 3,206,955 3,206,955 3,206,955 3,206,955 3,206,955 3,206,955 Shared Pool Size(M) 304 384 464 544 624 704 784 864 SP Size Factr 0.43 0.55 0.66 0.77 0.89 1.00 1.11 1.23 944 1,024 1,104 1,184 1,264 1,344 1,424 1.34 1.45 1.57 1.68 1.80 1.91 2.02 78 78 78 78 78 78 78 7,626 7,626 7,626 7,626 7,626 7,626 7,626 64,842 64,842 64,842 64,842 64,842 64,842 64,842 1.00 1.00 1.00 1.00 1.00 1.00 1.00 31 31 31 31 31 31 31 1.00 1.00 1.00 1.00 1.00 1.00 1.00 3,206,955 3,206,955 3,206,955 3,206,955 3,206,955 3,206,955 3,206,955 Back to Advisory Statistics Back to Top

SGA Target Advisory

SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads 1,024 2,048 3,072 4,096 5,120 6,144 7,168 8,192 Back to Advisory Statistics Back to Top

0.25 0.50 0.75 1.00 1.25 1.50 1.75 2.00 9,060 7,612 7,563 7,451 7,423 7,397 7,385 7,385 9,742,760 7,948,245 7,886,258 7,748,338 7,713,470 7,680,927 7,666,980 7,666,980 Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics Back to Top

Wait Statistics

? ? Buffer Wait Statistics Enqueue Activity Back to Top

Buffer Wait Statistics

?

ordered by wait time desc, waits desc

Waits Total Wait Time (s) Avg Time (ms) Class data block undo header file header block undo block 3 616 8 7 0 0 0 0 23 0 0 0 Back to Wait Statistics Back to Top

Enqueue Activity

? ? ?

only enqueues with waits are shown

Enqueue stats gathered prior to 10g should not be compared with 10g data ordered by Wait Time desc, Waits desc

Succ Gets 14,075 964 24 4,223 10,548 1 121,761 103 9,933 12 18 16 3 3 11 14 2 2 6 Failed Gets 0 0 0 0 0 0 6 0 0 0 0 0 0 0 3 0 0 0 0 Wt Time (s) 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Av Wt Time(ms) 0.43 0.32 9.00 1.22 0.67 35.00 0.43 0.65 0.54 1.42 0.38 0.50 0.67 0.33 0.33 1.00 1.00 1.00 0.00 Enqueue Type (Request Reason) FB-Format Block US-Undo Segment WF-AWR Flush HW-Segment High Water Mark CF-Controlfile Transaction TX-Transaction (index contention) TM-DML PS-PX Process Reservation TT-Tablespace TD-KTF map table enqueue (KTF dump entries) TA-Instance Undo PI-Remote PX Process Spawn Status MW-MWIN Schedule DR-Distributed Recovery TS-Temporary Segment AF-Advisor Framework (task serial …… 此处隐藏：3766字，全部文档内容请下载后查看。喜欢就下载吧 ……