/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 vote354 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote383 views3 answers
Constraint sql
SQL
8 votes329 views2 answers
Python simple connect to mysql
SQL
0 vote304 views2 answers
Avg() sql
SQL
0 vote322 views1 answer
Is not sql
SQL
0 vote367 views2 answers
Identity syntax in sql
SQL
1 vote303 views2 answers
Procedure pl/sql
SQL
0 vote327 views1 answer
Java check if something is in mysql table
SQL
4 votes344 views4 answers
What is primary key
SQL
6 votes331 views2 answers
Mysql get yesterday
SQL