[QUERY]실행된 쿼리 내역 조회

V$SQLTEXT, V$SQL, V$SQLAREA 를 이용할 수 있다.

SELECT PIECE, SQL_TEXT
FROM V$SQLTEXT
WHERE ADDRESS = '&sqladdress'
ORDER BY 1;

SELECT SQL_TEXT, SCHEMANAME, MACHINE, TERMINAL, PROGRAM
FROM  V$SQLAREA A, V$SESSION B
WHERE A.ADDRESS =B.SQL_ADDRESS

SELECT SQL_TEXT, PARSING_SCHEMA_NAME, MODULE, LAST_LOAD_TIME, LAST_ACTIVE_TIME
FROM V$SQLAREA
WHERE LAST_LOAD_TIME BETWEEN SYSDATE - 1 AND SYSDATE
    AND PARSING_SCHEMA_NAME <> 'SYS'
    AND SQL_TEXT LIKE 'UPDATE%'
ORDER BY LAST_LOAD_TIME;