PGA usage per user

set lines 132
set pages 1000
col username for a30
col name for a30
select a.username,b.name STATISTIC_NAME, round(sum(c.value/1024)) PGA_USAGE_KB
from v$session a, v$statname b, v$sesstat c
where b.statistic# in (25) and a.sid=c.sid and b.statistic#=c.statistic#
and a.username is not null
group by a.username, b.name
order by 1,2
/