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

On Jun 6, 3:16 pm, joel garry <joel-ga..._at_home.com> wrote:
>
> > Sounds like you probably have 4 gig of os memory serving as a file
> > buffer cache ... why?
>
> Nothing before now ever stimulated me to look at it. Also, not using
> direct I/O. Unable to test when it was new, due to RAID-5 salespeople
> having their way.
>
> This crashconf thingy tells me I'm using 1.6G. I'm hoping that's
> usage rather than just some configuration, but I don't see any such
> value in the .h file. The man is a bit unclear on that.

>
> > Most oracle hpux installs should have the two parameters dbc_min_pct
> > and dbc_max_pct set to very close if not the same values
>
> No argument there, although seeing comments elsewhere about setting it
> so you have good hit ratios doesn't give me the warm'n'fuzzies.
>
> Being able to say "hey, want a couple of free G on the production
> server?" right before a new division is added might get some notice,
> even without any business performance issues, so thanks!

Ok confused as usual. Are you going through the os buffer cache when oracle is doing reads and writes?

If so then be especially careful when considering changes. We run raw here for performance related reasons. Received on Fri Jun 08 2007 - 04:17:16 CDT