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 vote185 views1 answer
Select top 3 sql
SQL
0 vote179 views1 answer
Oracle sql date summer time
SQL
9 votes185 views4 answers
How to remove duplicate in sql
SQL
0 vote188 views1 answer
Mod in sql
SQL
0 vote204 views1 answer
Sql server list table sizes
SQL
0 vote184 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote194 views1 answer
Convert rows into columns in oracle
SQL
1 vote210 views1 answer
Cannot drop database because it is currently in use
SQL
2 votes202 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote203 views1 answer
Is not sql
SQL