query to check cpu utilization in oracle database
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;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
