/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 vote246 views2 answers
How to install psql in ubuntu
SQL
18 votes231 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote244 views1 answer
How to check rollback status in oracle
SQL
0 vote212 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote215 views1 answer
EnvironmentError: mysql_config not found
SQL
3 votes200 views2 answers
Get current year sql
SQL
0 vote215 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote245 views1 answer
T-SQL Create Trigger
SQL
9 votes186 views3 answers
Show table columns mysql command line
SQL
0 vote208 views2 answers
Compound operator in sql
SQL