--- CPU USAGE BY USER
SELECT s.sid,
s.serial#,
nvl(s.username, '[ORACLE PROCESS]')
user_name,
s.osuser os_user,
k.ksusestv cpu_usage,
s.program,
s.client_info,
s.module,
s.machine,
s.action,
s.logon_time
FROM v$session s,
sys.x$ksusesta k
WHERE k.indx = s.sid
AND k.ksusestn = 12
AND s.type != 'BACKGROUND'
ORDER BY
k.ksusestv DESC
