dbc_max_pct & dbc_min_pct

[Md. Farhan A Azam]

Hi Gurus,

I want to chnage the value of

dbc_max_pct & dbc_min_pct value as the buffer cache size is 12 GB, i want to reduce it to 4 GB,So kindly tellthat how can i calculate the max & min value

[Pete Randall]

Actually the "standard" recommendation is to set dbc_min_pct and dbc_max_pct so your buffer cache comes out around 400MB. The way to calculate it is to multiply 3 or 4 percent times your total memory and see how close that is to the recommended 400MB. Then adjust as needed.


Pete

[James R. Ferguson · Accepted solution]

Hi:

They are PERCENTAGES of your physical memory!

Hence 'int(4/x*100)' will be the integer percentage (the value) you want for a 4GB buffer cache where "x" is your total physical memory. Make this 'dbc_max_pct' and choose what you want for 'dbc_min_pct' [probably 2%].

Regards!

...JRF...

[Md. Farhan A Azam]

Hi,

Thanks for your prompt support.

[Md. Farhan A Azam]

Hi,

Thanks for your prompt support.