Re: Shared Pool Size

Kurt

Without seeing the query you ran, I assume this is looking at dynamic views (v$ views). If that's the case, these are a snapshot of the memory usage at a point in time. You should run the query a number of times to see if this is the normal free usage before considering reducing it.

HTH. Pete

Kurt Troyer wrote:

> I have run a query I found in a tuning book to review the amount of
> memory left for Shared Pool Size. The results are below. Given that I
> am not even using half of the size that I allocated, would I be better
> off reducing the size of the shared pool by say 10 meg and reallocating
> that amount to buffer cache?
>
> Shared Pool Size Free Bytes Percent Free
> ---------------- ------------ ------------
> 30,000,000 19,520,736 65.06912
>
> Thanks,
>
> Kurt Troyer

--

Regards

Pete

Received on Tue Jun 15 1999 - 12:27:30 CDT