Re: how to monitor memory usage?

seisee_at_my-deja.com wrote:
>
> Hi all,
>
> I would appreciate if somebody can tell me if there's any way to
> perform monitoring towards the % of shared memory usage?
> How to check the % of usage of share memory?
> And how to monitor it?
> Will the database crash if it exceed the limit?
>
> Thanks a lot for all of your replies.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Start with v$sgastat for SGA, and v$sesstat for session memory.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse