Query regarding process memory usage

From: Deepak <deepank_mca@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Wed, 10 Sep 2008 07:36:16 -0700 (PDT)

Hi,

With below script we can find out actual Memory used by all sessions connected 
to the database. Similarly I need to find out actual memory used by all 
sessions by SNAP_ID (from AWR views). Is there any way to find out this 
information in Oracle 10g?


compute sum of maxmem on report
break on report

select se.sid,n.name, 
       max(se.value) maxmem
from v$sesstat se,
     v$statname n
where n.statistic# = se.statistic#
and   n.name in ('session pga memory','session pga memory max',
                 'session uga memory','session uga memory max')
group by n.name,se.sid
order by 3
/

Thanks for your help in advance.

Thanks,
Deepak


      
--
//www.freelists.org/webpage/oracle-l

Query regarding process memory usage

Other related posts: