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 vote111 views1 answer
Import sql file mysql commadn line
SQL
11 votes116 views2 answers
Mysql disable safe mode
SQL
0 vote108 views1 answer
Enable full text search mysql
SQL
0 vote95 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote138 views1 answer
Sql alter column name sql server
SQL
0 vote114 views1 answer
Unique index in mysql
SQL
8 votes100 views2 answers
Sqlsrv default port
SQL
0 vote135 views1 answer
Add new column in sql with foreign key
SQL
0 vote108 views1 answer
Rows, INSERT INTO, Returning
SQL
2 votes113 views2 answers
Mysql show table column comments sql
SQL