Query regarding process memory usage

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')

Thanks for your help in advance.

Thanks,
Deepak       

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