resource.sql

select a.sid,
       a.username,
       substr(c.name,1,20) "NAME",
       b.value
  from v$session a,
       v$sesstat b,
       v$statname c
 where a.sid   = b.sid
 and   b.statistic#  = c.statistic#
 and   b.value      != 0
 and   a.username = upper('cbo_web')
 order by b.value desc;