cancel
Showing results for 
Search instead for 
Did you mean: 

dbc_max_pct & dbc_min_pct

SOLVED
Go to solution
Md. Farhan A Azam
Trusted Contributor

dbc_max_pct & dbc_min_pct

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
4 REPLIES
Pete Randall
Outstanding Contributor

Re: dbc_max_pct & dbc_min_pct

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

Pete
James R. Ferguson
Acclaimed Contributor
Solution

Re: dbc_max_pct & dbc_min_pct

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
Trusted Contributor

Re: dbc_max_pct & dbc_min_pct

Hi,

Thanks for your prompt support.
Md. Farhan A Azam
Trusted Contributor

Re: dbc_max_pct & dbc_min_pct

Hi,

Thanks for your prompt support.