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 vote242 views1 answer
What is int in mysql
SQL
0 vote222 views1 answer
Go install mysql
SQL
2 votes232 views1 answer
Sql count having
SQL
3 votes246 views1 answer
Sql case update
SQL
0 vote236 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote247 views1 answer
Mysql case when null
SQL
16 votes302 views2 answers
Sql vs nosql
SQL
5 votes248 views6 answers
Sql foreign key
SQL
8 votes246 views2 answers
Safe update mode in mysql
SQL
0 vote222 views1 answer
Inspecting a column unique/distinct values in SQL
SQL