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 vote329 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
11 votes313 views1 answer
Get ddl materialized view oracle
SQL
1 vote295 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote297 views1 answer
View to table
SQL
12 votes310 views2 answers
Update column data type postgres
SQL
0 vote318 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote270 views8 answers
Convert sql query to linq online
SQL
0 vote307 views1 answer
Sql contains numeric characters
SQL
1 vote331 views1 answer
Liquibase alter column type / length
SQL
0 vote296 views1 answer
Inner joint
SQL