SELECT sess.SID, sess.username, sess.osuser, sess.program,
sess.machine, s.statistic#, NAME, VALUE
FROM v$sesstat s, v$statname n, v$session sess
WHERE n.statistic# = s.statistic#
AND sess.SID = s.SID
AND n.statistic# IN (9, 42)

Fonte: http://oraclemais.blogspot.com/