/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 vote314 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
3 votes320 views1 answer
Oracle user privileges
SQL
29 votes318 views6 answers
Delete all rows from table mysql
SQL
0 vote371 views1 answer
Drop a view in sqlite
SQL
1 vote348 views5 answers
Postgresql difference between two dates in days
SQL
0 vote314 views1 answer
Uncomment listen_address=localhost
SQL
2 votes318 views1 answer
Drop table purge
SQL
0 vote316 views1 answer
Except in sql alchemy
SQL
1 vote375 views1 answer
How to set up a trigger in sql
SQL
15 votes317 views2 answers
Install mysql 8 ubuntu 18.04
SQL