AMM db_buffer_cache advisory question
Hi,
We have an 11.2.0.4 SE environment running AMM. After running many statspack reports it seems to suggest increasing the buffer pool will approximate reduce the physical reads considerably:
Buffer Pool Advisory DB/Inst: ABERLV1/aberlv1 End Snap: 582
-> Only rows with estimated physical reads >0 are displayed
-> ordered by Pool, Block Size, Buffers For Estimate
Est
Phys Estimated Est
Size for Size Buffers Read Phys Reads Est Phys % dbtime
P Est (M) Factr (thousands) Factr (thousands) Read Time for Rds
--- -------- ----- ------------ ------ -------------- ------------ --------
D 48 .1 6 2.4 1,793,308 2,262,570 55.3
D 96 .2 12 2.2 1,661,732 2,081,407 50.9
D 144 .3 18 2.0 1,536,097 1,908,423 46.7
D 192 .4 24 1.9 1,416,598 1,743,889 42.6
D 240 .5 29 1.7 1,302,371 1,586,613 38.8
D 288 .6 35 1.6 1,193,048 1,436,090 35.1
D 336 .7 41 1.4 1,088,888 1,292,675 31.6
D 384 .8 47 1.3 990,411 1,157,085 28.3
D 432 .8 53 1.2 897,895 1,029,702 25.2
D 480 .9 59 1.1 811,027 910,097 22.3
D 512 1.0 63 1.0 755,863 834,142 20.4
D 528 1.0 65 1.0 729,030 797,197 19.5
D 576 1.1 71 0.9 651,115 689,918 16.9
D 624 1.2 76 0.8 576,897 587,730 14.4