Re: Tuning attempt

afilonov_at_yahoo.com (Alex Filonov) 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.

OK, after getting under fire (looks like I deserve it), correction: scratch "give it as much as you can" part.

> 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 - 15:37:53 CDT