/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

4 votes335 views1 answer
Data types in sql
SQL
0 vote303 views1 answer
Drop all data from tables
SQL
0 vote310 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote347 views3 answers
How to assign custom id in mysql
SQL
6 votes324 views2 answers
Postgresql restore from dump
SQL
3 votes305 views2 answers
Sqlite show table definition
SQL
1 vote305 views3 answers
Grant syntax in sql
SQL
1 vote295 views2 answers
Reset mysqli fetch_arra
SQL
0 vote344 views1 answer
How to check database engine in mysql
SQL
2 votes319 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL