[oracle]오라클 실행 쿼리 이력 확인(FULLTEXT)

오라클 실행 쿼리 이력 확인(FULLTEXT)

SELECT 
	DBMS_LOB.SUBSTR(SQL_FULLTEXT, 3000, 1) as C1,
    DBMS_LOB.SUBSTR(SQL_FULLTEXT, 3000, 3001) as C2,
    DBMS_LOB.SUBSTR(SQL_FULLTEXT, 3000, 6001) as C3,
    DBMS_LOB.SUBSTR(SQL_FULLTEXT, 3000, 9001) as C4,
    DBMS_LOB.SUBSTR(SQL_FULLTEXT, 3000, 12001) as C5,
    DBMS_LOB.SUBSTR(SQL_FULLTEXT, 3000, 15001) as C6
FROM "V$SQLAREA" 
WHERE 
PARSING_SCHEMA_NAME = '' 			-- 디비 접속 계정
AND LAST_ACTIVE_TIME > '2024-03-26'	-- 일자	
AND SQL_TEXT LIKE '%%' -- 쿼리네 포함된 문자열
ORDER BY LAST_ACTIVE_TIME DESC;