/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 vote224 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
13 votes226 views3 answers
Insert mysql ifile nto database
SQL
0 vote237 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
20 votes229 views6 answers
Change password in mysql
SQL
0 vote190 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote173 views1 answer
How to connect sql server using ip address in c#
SQL
2 votes213 views1 answer
Sql server find table name
SQL
0 vote228 views2 answers
Advantages of stored procedures sql
SQL
0 vote242 views1 answer
Select place default lat long
SQL
16 votes219 views4 answers
Mysql import from sql file
SQL