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 vote167 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote145 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote145 views1 answer
What is mysql_pconnect
SQL
0 vote127 views1 answer
Sql show all users
SQL
0 vote137 views1 answer
Mysql replication change database name
SQL
24 votes135 views5 answers
Sql server insert into select
SQL
0 vote136 views3 answers
Condition in count sql
SQL
1 vote197 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote121 views1 answer
Sql new line output
SQL
3 votes138 views2 answers
How to load files in mysql
SQL