sessions by pga usage.sql
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
/
Discussion ¬