Database Tuning (MOSC)

MOSC Banner

AMM db_buffer_cache advisory question

edited Feb 13, 2015 10:01AM in Database Tuning (MOSC) 5 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center