Re: Tuning attempt

don't follow this advice :)

On 8 Apr 2003 08:19:21 -0700, afilonov_at_yahoo.com (Alex Filonov) wrote:

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

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Tue Apr 08 2003 - 13:59:19 CDT