Oracle cpu per session

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

2 votes228 views3 answers
Current setting postgres timezone
SQL
0 vote220 views1 answer
Sql server insert inner join
SQL
41 votes252 views6 answers
Alter table add column in SQL Server
SQL
18 votes178 views2 answers
How to get all the tables displayed in oracle
SQL
49 votes215 views6 answers
Alter table add column
SQL
0 vote219 views1 answer
Add computed column to table sql server
SQL
6 votes240 views1 answer
How to get the size of the database in postgresql
SQL
-1 vote236 views1 answer
Phinehas Psalm 106
SQL
0 vote224 views1 answer
Oracle list datafiles
SQL
0 vote242 views1 answer
Default order by in mysql
SQL