Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 10th, 2009
SELECT username,VALUE||'bytes'"Current UGA memory"FROM v_$session sess, v_$sesstat sstat, v_$statname sname
WHERE sess.sid = sstat.sid
AND sstat.statistic# = sname.statistic#
AND sname.name ='session uga memory';