ORACLE
ORACLE CPU 사용률 확인 쿼리
정보 집합
2023. 12. 27. 14:25
반응형
SELECT D.USERNAME
, A.VALUE CPU_USAGE
, A.SID
, D.SERIAL#
, D.BLOCKING_SESSION_STATUS
, C.SQL_FULLTEXT
FROM V$SESSION D, V$SESSTAT A, V$STATNAME B, V$SQLAREA C
WHERE A.SID = D.SID
AND A.STATISTIC# = B.STATISTIC#
AND B.NAME LIKE '%CPU used by this session%'
AND D.PREV_SQL_ID = C.SQL_ID
-- AND D.BLOCKING_SESSION_STATUS = 'VALID'
AND ROWNUM <= 10
ORDER BY A.VALUE DESC;
반응형