Re: Kernel parameter recommendations for HP-UX 11.11 in regard to SGA size

From: Swoop <swoop_at_doesnotwork.com>
Date: Wed, 06 Jun 2007 18:23:05 +1000
Message-ID: <46666e8e$0$993$afc38c87@news.optusnet.com.au>

>> Just wondering how others have configured the following parameters
>>
>> bufpages
>> dbc_max_pct
>> dbc_min_pct
>> nbuf

>
> I would recommend setting the dbc_max_pct very close to the
> dbc_min_pct otherwise hpux tends to keep increasing the size up to the
> dbc_max_pct.
>
> If you take the default value of 50 for dbc_max_pct that will have 2
> gig of os memory file caching that oracle ( hopefully if you have
> configured your oracle correctly ) won't even use.
>
> Probably 256 meg or less ( 128 maybe ) if is adequate so figure out 4
> gig times what number gives you that and set both dbc_max_pct and
> dbc_min_pct to the same value.
>
> The other ones I would have to double check at work tomorrow but I
> think they both should be zero.
>
> Check out the hp documentation just do a google on dbc_max_pct ...
>

Ok, thanks for that as it confirms what I was thinking apart from setting dbc_min_pct and dbc_max_pct to the same value. I will set them both the same such that 256Mb is allocated. Now I just have to talk the sysadmin into making the change and then bouncing the server.

Then I'll have more memory available to allocate to the databases as well. Received on Wed Jun 06 2007 - 03:23:05 CDT