db session

 SELECT s.sid, s.serial#, p.spid as "OS PID", s.username,

s.module, st.value/100 as "DB Time (sec)",

stcpu.value/100 as "CPU Time (sec)",

round(stcpu.value / st.value * 100,2) as "%CPU"

FROM v$sesstat st, v$statname sn, v$session s,

v$sesstat stcpu, v$statname sncpu, v$process p

WHERE sn.name = 'DB time’

AND st.statistic# = sn.statistic#

AND st.sid = s.sid

AND sncpu.name = 'CPU used by this session’

AND stcpu.statistic# = sncpu.statistic#

AND stcpu.sid = st.sid

AND s.paddr = p.addr

AND s.last_call_et < 1800

AND s.logon_time > (SYSDATE - 240/1440)

AND st.value > 0;