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

-1 vote94 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote145 views1 answer
Hive batch drop table
SQL
0 vote158 views1 answer
Define a variable in mysql from select
SQL
4 votes139 views1 answer
Datepart postgres
SQL
3 votes185 views3 answers
Restart mysql mac
SQL
1 vote176 views1 answer
How to get alternate records from a table in sql
SQL
0 vote137 views1 answer
Psql attribute cannot login
SQL
0 vote152 views1 answer
Compare two tables to find unmatched records
SQL
1 vote147 views1 answer
Tsql get beginning of year
SQL
4 votes153 views1 answer
Create column mysql terminal
SQL