Cheeky Cockatoo

col name for a15
col username for a20
set pages 100
select a.sid, b.username, a.value, c.name
from v$sesstat a, v$session b, v$statname c
where a.sid = b.sid
and a.statistic# = c.statistic#
and c.statistic# = 4
order by 3;