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 vote373 views1 answer
Alter boolean column postgresql
SQL
0 vote392 views1 answer
Table structure in sql
SQL
2 votes394 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote397 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote364 views2 answers
Azure sql-datenbank
SQL
0 vote376 views1 answer
Command line mysql xampp
SQL
0 vote345 views1 answer
Sql auto_increment syntax
SQL
0 vote373 views1 answer
Close sql query vb.net
SQL
0 vote352 views1 answer
Oracle drop default value
SQL
0 vote316 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL