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

3 votes106 views1 answer
Oracle wait
SQL
4 votes154 views1 answer
How to check last gather stats on table in oracle
SQL
1 vote120 views1 answer
Oracle update with sequence
SQL
0 vote117 views1 answer
Ajouter une clé etrangere mysql
SQL
0 vote111 views1 answer
Sql server manager close connection
SQL
1 vote112 views1 answer
Restart identity postgresql
SQL
0 vote115 views1 answer
Can't connect to postgresql mac os
SQL
0 vote151 views2 answers
How to prevent sql injection in java
SQL
0 vote109 views1 answer
Mysql cdn link
SQL
0 vote108 views1 answer
How change the field place in mysql
SQL