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 vote358 views1 answer
Hue hive UploadingTextFiletoHive
SQL
7 votes356 views2 answers
Mysql check db size
SQL
0 vote339 views1 answer
Search mysql database for column
SQL
3 votes341 views2 answers
To_char sql
SQL
0 vote308 views1 answer
Replace sqlalchemy
SQL
1 vote334 views1 answer
How to delete data from sql database in android
SQL
0 vote322 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
1 vote335 views1 answer
Postgresql export output table as a csv
SQL
8 votes345 views1 answer
Sql remove leading spaces
SQL
0 vote307 views1 answer
Python mysql query where
SQL