col mem_val form a28
     select value, sid, n.name|| ‘(‘||s.statistic#||’)’ mem_val
     from v$sesstat s , v$statname n
     where s.statistic# = n.statistic#
     and n.name like ‘session pga memory%’
     order by 1 desc
/