/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 vote171 views1 answer
10000000000000000000 am to meters
SQL
0 vote205 views2 answers
Clauses in mysql
SQL
4 votes187 views2 answers
What is table in sql
SQL
0 vote237 views1 answer
How to find sql server name
SQL
0 vote177 views2 answers
How to display enum value sql server
SQL
0 vote202 views1 answer
Sql date with year
SQL
16 votes164 views2 answers
Gremove folder from git
SQL
0 vote187 views1 answer
Mysql select where field is a value
SQL
0 vote171 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote191 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL