/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

11 votes295 views1 answer
Get ddl materialized view oracle
SQL
0 vote273 views2 answers
Cascade syntax in sql
SQL
0 vote279 views1 answer
Mysql add to value
SQL
0 vote273 views1 answer
Uncomment listen_address=localhost
SQL
0 vote282 views1 answer
Incorrect string value: mysql
SQL
0 vote282 views1 answer
Show create table in postgresql
SQL
6 votes290 views1 answer
Postgres get size of database
SQL
9 votes294 views2 answers
Sql limit to 5 results
SQL
0 vote299 views2 answers
Sql query inner join 3 tables
SQL
0 vote319 views1 answer
What logs are available on RDS MySQL?
SQL