Path: news.f.de.plusline.net!news-fra1.dfn.de!news.visyn.net!news2.arglkargh.de!news.n-ix.net!newsfeed.freenet.de!feeder.news-service.com!feeder2.cambrium.nl!feeder3.cambrium.nl!feed.tweaknews.nl!63.218.45.10.MISMATCH!nx01.iad01.newshosting.com!newshosting.com!198.186.194.251.MISMATCH!news-out.readnews.com!transit4.readnews.com!postnews.google.com!q19g2000prn.googlegroups.com!not-for-mail
From:  hpuxrac <johnbhurley@sbcglobal.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: Kernel parameter recommendations for HP-UX 11.11 in regard to SGA size
Date: Wed, 06 Jun 2007 11:51:16 -0700
Organization: http://groups.google.com
Lines: 20
Message-ID: <1181155876.521523.325350@q19g2000prn.googlegroups.com>
References: <4665340f$0$22417$afc38c87@news.optusnet.com.au>
   <1181089675.265857.272630@k79g2000hse.googlegroups.com>
   <46666e8e$0$993$afc38c87@news.optusnet.com.au>
NNTP-Posting-Host: 70.228.67.48
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1181155883 12976 127.0.0.1 (6 Jun 2007 18:51:23 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 6 Jun 2007 18:51:23 +0000 (UTC)
In-Reply-To: <46666e8e$0$993$afc38c87@news.optusnet.com.au>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: q19g2000prn.googlegroups.com; posting-host=70.228.67.48;
   posting-account=Dz_3bQ0AAAC5LZNB2NPEJz1sl_a8qcDY
Xref: news.f.de.plusline.net comp.databases.oracle.server:199036

On Jun 6, 4:23 am, Swoop <s...@doesnotwork.com> wrote:

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

Guess I should have added that there's an easy way to implement
checking what kind of hit ratio hpux is giving you from the os buffer
cache.  If you implement sar based reporting one of the metrics you
can get is the hits.  Here we trigger off a run every 10 minutes to
get baseline os statistics.

Not that you want to live and die by that hit ratio but it does give
you something to consider.  Normally even with a fairly small number
for dbc_min and max the ratio is pretty good until Data Protector
driven file system backups start executing.