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;
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;