show parameter pga  ---PGA_AGGREGATE_TARGET
show parameter sga  
show parameter cache
show parameter buffer
show parameter pool
show parameter process

select sum(value) from v$sesstat s, v$statname n, v$session
where s.statistic# = n.statistic# and v$session.sid = s.sid and
name like '%memory'and value > 0 ;


SELECT username,sess.sid,sum(trunc((value/1024))) MEM_USED
FROM v$session sess, v$sesstat stat, v$statname name
WHERE sess.sid = stat.sid
AND stat.statistic# = name.statistic#
AND name.name in ('session uga memory' ,'session pga memory')
group by username,sess.sid
order by  MEM_USED
/


set linesize 132
set pages 999
col program for a30
select spid,username,program,sum(PGA_USED_MEM) ,sum(pga_alloc_mem),
sum(pga_freeable_mem),sum(pga_max_mem)
from v$process
group by spid,username,program
having sum(PGA_USED_MEM)>10000000  --- > 10M
order by 6
/

select username, server, sum(value), name from v$sesstat s, v$statname n, v$session
where s.statistic# = n.statistic# and v$session.sid = s.sid and
name like '%memory'and value > 0
group by username, server, name;


SET linesize 200 LONG 1000 PAGES 50 LINES 132 feedback off
BREAK ON users
COMPUTE SUM OF sharable_mem ON users
COMPUTE SUM OF persistent_mem ON users
COMPUTE SUM OF runtime_mem ON users
SELECT username users,
sql_text,
executions,
parse_calls,
sharable_mem,
persistent_mem
FROM v$sqlarea a, dba_users b
WHERE a.parsing_user_id = b.user_id
ORDER BY 5;