/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

1 vote362 views1 answer
How to test for sql injection
SQL
0 vote327 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
-1 vote417 views1 answer
How to Activate the database
SQL
3 votes345 views3 answers
Concatenation in sql
SQL
2 votes369 views1 answer
Revokeprivileges mysql
SQL
0 vote326 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
-1 vote328 views2 answers
On delete set default sql server
SQL
0 vote354 views1 answer
Sql server select record with max id
SQL
5 votes335 views1 answer
Ascending order and where in sql
SQL
6 votes394 views4 answers
Mysql group by month
SQL