/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 vote228 views1 answer
How to get all values in a table mysql in c#
SQL
1 vote129 views1 answer
OstgreSQL version
SQL
1 vote119 views3 answers
Postgresql connect to database
SQL
1 vote113 views1 answer
How to get mysql db size
SQL
22 votes138 views3 answers
Year format in date mysql
SQL
12 votes131 views5 answers
Rename table in mysql
SQL
13 votes142 views4 answers
Command line mysql import
SQL
0 vote118 views1 answer
Postpresql relation not found
SQL
1 vote147 views1 answer
Sql order by timestamp
SQL
7 votes121 views1 answer
Append column sql
SQL