[oracle_br] alguem pode me ajudar a turbinar e a esse select ? em especial (VALUE/100)/60 as "Consumo p/ min"

[Alex Castro]

select
   ss.username,
   se.SID,
   (VALUE/100)/60 as "Consumo p/ min"
from
   v$session ss,
   v$sesstat se,
   v$statname sn
where
   se.STATISTIC# = sn.STATISTIC#
and
   NAME like '%CPU used by this session%'
and
   se.SID = ss.SID
and
   ss.status='ACTIVE'
and
   ss.username is not null
order by VALUE desc;


www.servercom.com.br


[As partes desta mensagem que não continham texto foram removidas]