ORACLE DB 쿼리 이력 확인
2023. 4. 27. 19:10ㆍ카테고리 없음
SELECT
last_active_time
,parsing_schema_name
,sql_text
FROM v$sqlarea
WHERE
parsing_schema_name <> 'SYS'
AND parsing_schema_name <> 'SYSMAN'
AND parsing_schema_name <> 'DBSNMP'
AND parsing_schema_name <> 'MDSYS'
AND parsing_schema_name <> 'EXFSYS'
ORDER BY
last_active_time DESC;