Re: SGA Diagnostics

From: Simon Maufe <maufe_at_daugherty.NOJUNK.com>
Date: 1997/10/01
Message-ID: <01bcceb7$980913c0$94a490a4@SNMAUF.MONSANTO.COM>#1/1

Here is a useful.sql I use to find things out, one of which is SGA usage

Simon

Sanlam <joe_at_soap.com> wrote in article
<01bcce60$82cff3e0$b6040a0a_at_com00331>...
> 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
>

begin 600 useful.sql
<encoded_portion_removed>
end Received on Wed Oct 01 1997 - 00:00:00 CDT