DBA Data[Home] [Help]

VIEW: SYS.V_$REPLAY_CONTEXT

Source

View Text - Preformatted

select "CONTEXT_ID","SID","ENDIANNESS","PROTOCOL_VERSION","CONTEXT_SIZE","SQL_HASH","DATABASE_ID","ENV_HASH","TIMEZONE","CHECKSUM","SCN","RESET_LOG_SCN","RESET_LOG_COUNTER","UNIQUE_SEQUENCES_CAPTURED","SEQUENCE_VALUES_CAPTURED","SEQUENCE_VALUES_REPLAYED","SYSDATE_VALUES_CAPTURED","SYSDATE_VALUES_REPLAYED","SYSTIMESTAMP_VALUES_CAPTURED","SYSTIMESTAMP_VALUES_REPLAYED","SYSGUID_VALUES_CAPTURED","SYSGUID_VALUES_REPLAYED","LOBS_CAPTURED","LOBS_REPLAYED","CON_ID" from v$replay_context
View Text - HTML Formatted

SELECT "CONTEXT_ID"
, "SID"
, "ENDIANNESS"
, "PROTOCOL_VERSION"
, "CONTEXT_SIZE"
, "SQL_HASH"
, "DATABASE_ID"
, "ENV_HASH"
, "TIMEZONE"
, "CHECKSUM"
, "SCN"
, "RESET_LOG_SCN"
, "RESET_LOG_COUNTER"
, "UNIQUE_SEQUENCES_CAPTURED"
, "SEQUENCE_VALUES_CAPTURED"
, "SEQUENCE_VALUES_REPLAYED"
, "SYSDATE_VALUES_CAPTURED"
, "SYSDATE_VALUES_REPLAYED"
, "SYSTIMESTAMP_VALUES_CAPTURED"
, "SYSTIMESTAMP_VALUES_REPLAYED"
, "SYSGUID_VALUES_CAPTURED"
, "SYSGUID_VALUES_REPLAYED"
, "LOBS_CAPTURED"
, "LOBS_REPLAYED"
, "CON_ID"
FROM V$REPLAY_CONTEXT