Re: Process/session memory use

Andrew Mobbs wrote:
>
> Anybody got a good script for reporting a breakdown of PGA/UGA/CGA
> memory use? I couldn't find one with Google.
>
> I'm not really sure what's possible, ideally I'd like to know how much is
> used by sort area, how much by cursors, how much by package variables etc.
>
> I hate being asked questions after 6pm on Friday.
>
> Thanks,
>
> --
> Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/

Have a look in v$sesstat for any statistic name containing 'memory'

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."