CPU USAGE BY current Users

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