/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 vote113 views1 answer
Select last 2 characters sql
SQL
0 vote112 views1 answer
Database get 10 user aleatory
SQL
0 vote150 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
2 votes153 views1 answer
Tsql copy table
SQL
0 vote128 views1 answer
Connect laravel to mysql on mac
SQL
0 vote98 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote106 views1 answer
Oracle job class
SQL
2 votes62 views1 answer
Sql view column data type
SQL
0 vote113 views1 answer
Drush run sql select
SQL
1 vote127 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL