Answers for "oracle query cpu usage"

oracle cpu usage

SELECT PARSING_SCHEMA_NAME, MODULE, SQL_ID, 
	   round(((CPU_TIME / 1e6) / 60), 2) AS CPU_TIME,
       EXECUTIONS, ROWS_PROCESSED, DISK_READS, FIRST_LOAD_TIME,
       LAST_LOAD_TIME, OPTIMIZER_COST, SQL_FULLTEXT
FROM V$SQLAREA
WHERE PARSING_SCHEMA_NAME IN ('schema_name')
ORDER BY PARSING_SCHEMA_NAME, CPU_TIME DESC;

query to check cpu utilization in oracle database

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;