Home » Find username consuming high CPU in Oracle

Find username consuming high CPU in Oracle

by tuanlp

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;

You may also like