SQL 최근 실행한 쿼리 히스토리 조회

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
;

출처 : https://ponyozzang.tistory.com/183