I have 25 gb of ram, should I allocate 24.9gb to library cache and 0.1gb to
buffer cache?
--
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 Tue Apr 08 2003 - 15:41:40 CDT
