cpu session

column program format a30
column username format a18
--set pagesize 0
Prompt ===========================================================
Prompt ** Sessions with CPU utlzn, Disk io details
Prompt ** file: sess_cpu.sql tms 10/jun/99
Prompt ===========================================================
set heading on
select
 p.spid thread,
 s.sid,
 substr(s.terminal,1,15) terminal ,
 substr(s.username,1,18) UserName ,
 decode(nvl(p.background,0),1,bg.description, s.program ) program,
 ss.value * 100   CPU_secs,
 physical_reads disk_io
 from v$process p,
        v$session s,
        v$sesstat ss,
        v$sess_io si,
        v$bgprocess bg
 where s.paddr=p.addr
   and ss.sid=s.sid
   and ss.statistic#=12
   and si.sid=s.sid
   and bg.paddr(+)=p.addr
   order by ss.value desc
/