Thanks Sam.

I also found another one in Metalink that may be helpful to other:

SELECT username, trunc((value/1024)) || ' Kbytes' "Current session memory"
FROM v$session sess, v$sesstat stat, v$statname name
WHERE sess.sid = stat.sid
AND stat.statistic# = name.statistic#
AND name.name = 'session uga memory';