/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 vote306 views1 answer
Sql contains numeric characters
SQL
5 votes329 views1 answer
Purge undo tablespace usage
SQL
6 votes360 views4 answers
Mysql get random row
SQL
0 vote318 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
1 vote323 views1 answer
Oracle compile schema
SQL
0 vote295 views2 answers
2nd max salary query in sql
SQL
0 vote252 views2 answers
Jupyter notebook connect to database
SQL
0 vote318 views1 answer
Dbms_output sql developer
SQL
1 vote353 views1 answer
Default
SQL
1 vote292 views1 answer
Search for tables with name postgresql
SQL