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

0 vote139 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
1 vote149 views2 answers
Sql insert timestamp
SQL
0 vote155 views1 answer
Postgresql import data from csv
SQL
0 vote150 views1 answer
Two inner joins sql
SQL
3 votes147 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote138 views1 answer
Oracle simple quote
SQL
2 votes140 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote141 views1 answer
Sql row number in result set
SQL
1 vote146 views1 answer
How to use db.execute
SQL
0 vote138 views1 answer
Database xml sql
SQL