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 vote155 views1 answer
Less mysql display
SQL
0 vote149 views1 answer
Sql change primary key to composite key
SQL
0 vote165 views1 answer
Reindex mssql table
SQL
13 votes155 views2 answers
Sql online compiler
SQL
0 vote153 views1 answer
Comma seperated join mssql
SQL
11 votes140 views1 answer
Oracle view ddl
SQL
0 vote200 views1 answer
How to compile a function in oracle
SQL
1 vote152 views1 answer
Oracle create program if no exists
SQL
0 vote313 views1 answer
The package java.sql is not accessible
SQL
0 vote153 views1 answer
Less than and between in sql query
SQL