Buffer Pool Advisory

[c*s*d*n]

Buffer Pool Advisory

Size for Size Buffers for Est Physical Estimated
P Estimate (M) Factr Estimate Read Factor Physical Reads
--- ------------ ----- ---------------- ------------- ------------------
D 16 .1 1,985 1.84 500,048,911
D 32 .2 3,970 1.83 497,547,162
D 48 .2 5,955 1.83 496,648,062
D 64 .3 7,940 1.82 495,609,614
D 80 .4 9,925 1.82 495,225,611
D 96 .5 11,910 1.82 494,979,601
D 112 .5 13,895 1.82 494,782,673
D 128 .6 15,880 1.76 479,013,272
D 144 .7 17,865 1.43 389,086,943
D 160 .8 19,850 1.17 318,401,469
D 176 .8 21,835 1.11 300,255,089
D 192 .9 23,820 1.05 285,059,474
D 208 1.0 25,805 1.00 271,696,986
D 224 1.1 27,790 0.93 252,627,807
D 240 1.2 29,775 0.88 239,212,154
D 256 1.2 31,760 0.81 219,665,844
D 272 1.3 33,745 0.68 183,632,607
D 288 1.4 35,730 0.56 152,975,242
D 304 1.5 37,715 0.36 98,167,852
D 320 1.5 39,700 0.20 55,282,037 <--

Try to set Buffer Pool to maximize physical reads, and reduce number of reads, set to 400 MB

谁能帮忙解释下 这个要求是什么意思？ 谢谢

[suiziguo]

AWR报告告诉你，当前Buffer Pool（208）偏小，最好能增加到400M。