/SQL/Query to check cpu utilization in oracle database

Query to check cpu utilization in oracle database

SELECT ss.USERNAME, se.SID, se.VALUE / 100 CPU_USAGE_SECONDS
FROM V$SESSION ss, V$SESSTAT se, V$STATNAME sn
WHERE se.STATISTIC# = sn.STATISTIC#
  AND NAME LIKE '%CPU used by this session%'
  AND se.SID = ss.SID
  AND ss.STATUS = 'ACTIVE'
  AND ss.USERNAME IS NOT NULL
ORDER BY VALUE DESC;

Source: dba-oracle.com

Similar codes

0 vote219 views1 answer
View psql output in horizontal scrolling
SQL
0 vote199 views1 answer
Postgresql delete limit
SQL
0 vote185 views1 answer
Metada in sql
SQL
25 votes246 views3 answers
Mysql command show tables
SQL
0 vote215 views1 answer
Oracle string substitution
SQL
0 vote207 views1 answer
How to put is null in where in clause
SQL
2 votes192 views1 answer
Oracle number to percentage
SQL
0 vote209 views1 answer
To_date sql
SQL
28 votes218 views4 answers
Mysql delete database
SQL
0 vote202 views1 answer
Sql replace id with name from another table
SQL