UGA - User Global Area or Session memory
PGA - Process Global Area
select name, sum(value/1024/1024) "MB" from v$statname n, v$session s, v$sesstat t where s.sid = t.sid
and n.statistic# = t.statistic# and s.TYPE = 'USER' and s.USERNAME is not null and n.name in ('session pga memory', 'session uga memory')
group by name
PGA - Process Global Area
select name, sum(value/1024/1024) "MB" from v$statname n, v$session s, v$sesstat t where s.sid = t.sid
and n.statistic# = t.statistic# and s.TYPE = 'USER' and s.USERNAME is not null and n.name in ('session pga memory', 'session uga memory')
group by name
No comments:
Post a Comment