Re: Tuning Assistance

From: Brian Gallagher <briang_at_iona.com>
Date: Thu, 24 Jun 1999 15:05:45 +0100
Message-ID: <7kte82$lb4$1@bvweb.dublin.iona.ie>

54.5% is very poor hit ratio for SQL area - you'll need to increase the SHARED_POOL size or pin appropriate packages in shared_pool or standardise querys to ensure maximum use of shared sql area

hope this helps
rgds
brian

>Library Cache:
>-------------
>all of my 'gethitratio' and 'pinhitratio' stats are 99.8% or higher,
>except for the SQL AREA. It is at 54.5% and 61.6% respectively.
>Reloads are about 1% of pins, and invalidations are near zero.
>Currently my shared_pool size is set at 128 MB, but if I issue the
>command "select * from v$sgastat where name = 'free memory'" throughout
you know. Learn what you don't. Received on Thu Jun 24 1999 - 09:05:45 CDT