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