Re: SGA Diagnostics

From: Kluged <kluged_at_ix.netcom.com>
Date: 1997/10/06
Message-ID: <3439DBCD.37BB@ix.netcom.com>#1/1

check how your buffer hit ratios are doing. if they are in the 90% range then you can reduce your db_block_buffers until you see the hit ratio drop below its current rate. if your ratio is currently below 90%, then increase db_block_buffers, which will in turn create a larger SGA. what do your latch statistics look like at this time?

Sanlam wrote:
>
> Hi
>
> Could anyone give me some info on determining how much of the SGA is being
> used. My SGA is currently 710MB in size and I am not convinved that
> everything is being used. I need to know how much of the SGA is being used
> by what because I have another 512MB memory available to me.
>
> I would also like some info on improving the hit ratio of the redo copy
> latch.
>
> Please Forward some ideas.
>
> Thanks
>
> akader_at_health.sanlam.co.za
Received on Mon Oct 06 1997 - 00:00:00 CDT