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 vote136 views1 answer
Providername system.data. mysql
SQL
0 vote125 views2 answers
Sql server Insert Into table
SQL
0 vote137 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote122 views1 answer
Sql inserted
SQL
0 vote126 views1 answer
Drop a field in psql django
SQL
0 vote118 views1 answer
Initcap in sql
SQL
0 vote128 views1 answer
Like date sql server not working
SQL
0 vote131 views1 answer
Open postgresql.conf in centos
SQL
0 vote118 views1 answer
How to change null display in psql
SQL
17 votes134 views2 answers
T_sql contains
SQL