Re: Tuning attempt

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:<3e933403$0$21985$cc9e4d1f_at_news.dial.pipex.com>...
> I have 25 gb of ram, should I allocate 24.9gb to library cache and 0.1gb to
> buffer cache?
>

Do you need to take everything literally? Of course there are restrictions on everything. And I don't think that you have only one instance of Oracle and there are no other applications which require RAM. I said "as much as you can", not "as much as you have". Of course, you need a lot of RAM for buffer cash and you usually CAN'T sacrifice much of it for shared pool. Same true for RAM required by OS, OS disk cache, dedicated server processes and lots of other stuff.

And, AFAIK, you can't have shared segment bigger than 2G on Win2K, which means that buffer cash + shared pool < 2G.

> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************
> "Alex Filonov" <afilonov_at_yahoo.com> wrote in message
> news:336da121.0304080719.5f4123c5_at_posting.google.com...
> > Marc Eggenberger <marc.eggenberger_at_itc.alstom.com> wrote in message
> news:<MPG.18fcb5bed6bd1c86989690_at_localhost>...
> > > Hi there.
> > >
> > > I play a bit with statspack and other tools to see what could be
> > > improved with my databases.
> > > I also tried TOAD and it says that my library cache pin hit ratio is
> > > 89.8674 and this is bad and thats because my shared pool area is too
> > > small ...
> > >
> > > my shared_pool_size is currently at 98765516
> > >
> > > I dont have any idea if this value is "high" or not. I know that you
> > > cant really say if its right if you dont know the application.
> > > But for a oracle 8.1.7 running on a W2k cluster (2x 1GHz, 3GB RAM) and
> > > the application beeing more a OLTP with about 60 sessions. The queries
> > > are more or less simple selects with joins over 5-10 tables and inserts
> > > (its a assessment tool).
> > >
> > > What are the range of values for shared_pool_size one should have in
> > > those db / application ranges?
> > > more like 10-20MB, 100MB or even more to 500MB?
> >
> >
> > The answer to this question is simple. Just give it as much as you can.
> > If you have severe RAM restrictions, try increasing shared pool until you
> have
> > decent pin hit ratio. BTW, you don't have MTS, I hope? If you do, you
> > need a lot of shared pool.
Received on Wed Apr 09 2003 - 10:32:01 CDT