Find username consuming high CPU in Oracle

Script to find the Username which causing bottleneck of CPU in Oracle

select * from (
SELECT  se.username, ROUND (value/100) "CPU Usage"
FROM v$session se, v$sesstat ss, v$statname st
WHERE ss.statistic# = st.statistic#
   AND name LIKE  '%CPU used by this session%'
   AND se.sid = ss.SID and ROUND (value/100) <> 0
   AND se.username IS NOT NULL
  ORDER BY value DESC) where rownum <= 10;

Related posts

How to deal with ORA-00020: maximum number of processes (%s) exceeded

How to resolve ORA-01111 ORA-01110 ORA-01157 in a physical standby database 

Công cụ tự động khai báo datafile – Oracle