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 vote187 views1 answer
Oracle grant on all tables in schema
SQL
12 votes207 views1 answer
Psql drop column
SQL
2 votes190 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote179 views1 answer
Alter precision
SQL
8 votes195 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote187 views2 answers
Connect to mysql server mac terminal
SQL
0 vote181 views1 answer
Min and max salary and name in sql
SQL
9 votes189 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote184 views1 answer
Procedure excute monthly oracle
SQL
0 vote206 views1 answer
How to alter length character varying postgres
SQL