[ORACLE] V$SQLAREA 를 통해 기록 보기 (sql recall history) [오라클]

V$SQLAREA

해당 예시는 오늘(SYSDATE) SQL 이 어떻게 실행되었는지 확인해 보기 위한 것입니다. 조건을 상세히 하거나 다른 뷰(V$SQL, etc)로 조회해 볼 수 있습니다.

  SELECT 
        LAST_ACTIVE_TIME, SQL_TEXT, 
        ELAPSED_TIME,
        FIRST_LOAD_TIME,
        LAST_LOAD_TIME,
        SQL_ID, SHARABLE_MEM, PERSISTENT_MEM, RUNTIME_MEM, 
        SORTS, VERSION_COUNT, LOADED_VERSIONS, OPEN_VERSIONS, USERS_OPENING, 
        FETCHES, EXECUTIONS, PX_SERVERS_EXECUTIONS, END_OF_FETCH_COUNT, USERS_EXECUTING, 
        LOADS,
        INVALIDATIONS, PARSE_CALLS, DISK_READS, 
        DIRECT_WRITES, BUFFER_GETS, APPLICATION_WAIT_TIME, CONCURRENCY_WAIT_TIME, CLUSTER_WAIT_TIME, 
        USER_IO_WAIT_TIME, PLSQL_EXEC_TIME, JAVA_EXEC_TIME, ROWS_PROCESSED, COMMAND_TYPE, 
        OPTIMIZER_MODE, OPTIMIZER_COST, OPTIMIZER_ENV, OPTIMIZER_ENV_HASH_VALUE, PARSING_USER_ID, 
        PARSING_SCHEMA_ID, PARSING_SCHEMA_NAME, KEPT_VERSIONS, ADDRESS, HASH_VALUE, 
        OLD_HASH_VALUE, PLAN_HASH_VALUE, MODULE, MODULE_HASH, ACTION, 
        ACTION_HASH, SERIALIZABLE_ABORTS, OUTLINE_CATEGORY, CPU_TIME,
        OUTLINE_SID, LAST_ACTIVE_CHILD_ADDRESS, REMOTE, OBJECT_STATUS, LITERAL_HASH_VALUE,
        IS_OBSOLETE, IS_BIND_SENSITIVE, IS_BIND_AWARE, CHILD_LATCH, 
        SQL_PROFILE, SQL_PATCH, SQL_PLAN_BASELINE, PROGRAM_ID, PROGRAM_LINE#, 
        EXACT_MATCHING_SIGNATURE, FORCE_MATCHING_SIGNATURE,
        BIND_DATA, TYPECHECK_MEM, 
        IO_CELL_OFFLOAD_ELIGIBLE_BYTES, IO_INTERCONNECT_BYTES, PHYSICAL_READ_REQUESTS, PHYSICAL_READ_BYTES, PHYSICAL_WRITE_REQUESTS, 
        PHYSICAL_WRITE_BYTES, OPTIMIZED_PHY_READ_REQUESTS, LOCKED_TOTAL, PINNED_TOTAL, IO_CELL_UNCOMPRESSED_BYTES, 
        IO_CELL_OFFLOAD_RETURNED_BYTES
    FROM V$SQLAREA
   WHERE 0 = 0
         AND TO_CHAR (LAST_ACTIVE_TIME, 'YYYYMMDD') =
                TO_CHAR (SYSDATE, 'YYYYMMDD')
ORDER BY LAST_ACTIVE_TIME DESC;
댓글 쓰기
가져가실 때, 출처 표시 부탁드려요! 감사합니다. 💗