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

2 votes185 views1 answer
Columns Present in a table
SQL
0 vote238 views1 answer
Alternative for LIMIT sql
SQL
1 vote209 views1 answer
Sql and
SQL
2 votes282 views1 answer
How to select from mssql
SQL
0 vote183 views1 answer
Sqlite select split string
SQL
0 vote221 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote201 views1 answer
Savepoint mysql script
SQL
0 vote207 views1 answer
Postgresql show owner of database
SQL
0 vote183 views1 answer
Procedure excute monthly oracle
SQL
0 vote188 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL