/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 vote262 views1 answer
Oracle list datafiles in tablespace
SQL
5 votes294 views1 answer
Oracle list days between two dates
SQL
1 vote286 views1 answer
Drop function
SQL
0 vote267 views1 answer
Nueva tabla mysql
SQL
1 vote290 views2 answers
How to combine 2 tables in MySQL
SQL
14 votes283 views2 answers
Oracle export trigger ddl
SQL
0 vote301 views4 answers
Sql rownum
SQL
1 vote270 views1 answer
Real world example of nosql
SQL
1 vote255 views1 answer
MySQL AND Operator
SQL
1 vote275 views1 answer
Oracle activate job
SQL