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 vote138 views1 answer
Declare or use variable in snowflake
SQL
0 vote129 views1 answer
Cross apply top for each row t1
SQL
1 vote95 views2 answers
Last working day in week date function in sql
SQL
0 vote157 views1 answer
To Create directory
SQL
1 vote131 views1 answer
Postgres first_value in gropby
SQL
0 vote126 views1 answer
Oracle grant create job
SQL
0 vote127 views1 answer
Oracle locked objects
SQL
0 vote119 views1 answer
Phpmyadmin mysql conflict
SQL
1 vote134 views1 answer
Mariadb get column names from table
SQL
0 vote140 views1 answer
Get date ISO in psql
SQL