/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 vote275 views3 answers
Postgresql grant alter table to user
SQL
7 votes257 views4 answers
How to reset the identity column in sql server
SQL
54 votes441 views6 answers
Sql rename column
SQL
3 votes304 views2 answers
Check data in table mysql
SQL
3 votes264 views3 answers
Docker create postgresql database
SQL
11 votes247 views2 answers
Sql between date range
SQL
0 vote293 views1 answer
Display all node label neo4j
SQL
0 vote256 views1 answer
Drop all data from tables
SQL
1 vote249 views1 answer
Postgresql convert text to float
SQL
0 vote264 views1 answer
IIF
SQL