Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!newsfeed.vmunix.org!news1.optus.net.au!optus!newsfeeder.syd.optusnet.com.au!news.optusnet.com.au!not-for-mail
Date: Thu, 07 Jun 2007 07:10:44 +1000
From: Swoop <swoop@doesnotwork.com>
User-Agent: Thunderbird 2.0.0.0 (Windows/20070326)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Kernel parameter recommendations for HP-UX 11.11 in regard to
 SGA size
References: <4665340f$0$22417$afc38c87@news.optusnet.com.au>   <1181041096.457893.231770@h2g2000hsg.googlegroups.com> <1181138865.822719.80480@k79g2000hse.googlegroups.com>
In-Reply-To: <1181138865.822719.80480@k79g2000hse.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 36
Message-ID: <46672278$0$17153$afc38c87@news.optusnet.com.au>
NNTP-Posting-Host: 210.49.99.139
X-Trace: 1181164152  17153 210.49.99.139
Xref: news.f.de.plusline.net comp.databases.oracle.server:199051


>>> 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.