Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Kernel parameter recommendations for HP-UX 11.11 in regard to SGA size

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

From: Swoop <swoop_at_doesnotwork.com>
Date: Thu, 07 Jun 2007 07:10:44 +1000
Message-ID: <46672278$0$17153$afc38c87@news.optusnet.com.au>

>>> Just wondering how others have configured the following parameters
>>> bufpages
>>> dbc_max_pct
>>> dbc_min_pct
>>> nbuf
>>> in regards to system buffer cache?
>> You need to configure the databas filesystems for directio, as Oracle
>> already has a buffer cache.
>> The above parameters are referring to the *O/S* buffer cache, which
>> you shouldn't use.
>> You need to read up the *platform specific* documentation for HP-UX
>> available onhttp://otn.oracle.com(tahiti.oracle.com only has generic
>> docs)

>
> Where exactly is the OP going to find any installation guide doc for
> those parameter that he cited? The oracle install guide for hpux has
> configuration information for the kernel and shared memory stuff ...
> not the ones the OP asked about.
>
> Now if you go into oracle metalink and do a search that's a better
> recommendation.
>
> Note 68105.1 has some relevant info for the OP.
>

Yeah this is where I got the 128Mb figure, "This is valid for old systems which has small amount of RAM installed."

Hence why I'm upping it to 256Mb

I'll try and get that hit ratio stuff from sar to check things out.

Also, I think if you set the (OS) buffer cache too high it doesn't actually use that figure as you can see the memory available with swapinfo -mt
however, I haven't fully worked out how it calculates that figure yet. Received on Wed Jun 06 2007 - 16:10:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US