Re: Increasing SHARED_POOL_SIZE bring down my SQL library cache miss ratio ???

Hi

I think you should try to tune your applications to use the same sql statements (as much as possible), consider using bind variables if it is possible instead of literals, etc.

premjhere_at_yahoo.co.in (Prem J Khanna) wrote in message news:<11af2de9.0207100032.4613f7f4_at_posting.google.com>...
> Guys,
>
> i am on 8.1.6/win2k.
>
> Quest's TOAD shows that my SQL library cache miss ratio is > 40 %
> which is not desirable ?
>
> what should be the value of this ?
>
> DB size is 13GB.
>
> The size of SGA is 1.25 GB
> The split up of SGA is
>
> BUFFER CACHE 800 MB
> SHARED POOL 270 MB
> JAVA POOL 20 MB
> LARGE POOL 140 MB
>
>
> should i increase my SHARED_POOL_SIZE now ?
> if so , how do i do that ?
> will increasing SHARED_POOL_SIZE bring down my SQL library cache miss ratio ?
>
> any precautions to be taken b4 doing that ?
>
> TIA.
Received on Thu Jul 11 2002 - 02:10:45 CEST