DBA Data[Home] [Help]

VIEW: SYS.V_$XSTREAM_APPLY_RECEIVER

Source

View Text - Preformatted

select "SID","SERIAL#","APPLY_NAME","STARTUP_TIME","SOURCE_DATABASE_NAME","ACKNOWLEDGEMENT","LAST_RECEIVED_MSG","TOTAL_MESSAGES_RECEIVED","TOTAL_AVAILABLE_MESSAGES","STATE","LAST_RECEIVED_MSG_POSITION","ACKNOWLEDGEMENT_POSITION","CON_ID" from v$xstream_apply_receiver
View Text - HTML Formatted

SELECT "SID"
, "SERIAL#"
, "APPLY_NAME"
, "STARTUP_TIME"
, "SOURCE_DATABASE_NAME"
, "ACKNOWLEDGEMENT"
, "LAST_RECEIVED_MSG"
, "TOTAL_MESSAGES_RECEIVED"
, "TOTAL_AVAILABLE_MESSAGES"
, "STATE"
, "LAST_RECEIVED_MSG_POSITION"
, "ACKNOWLEDGEMENT_POSITION"
, "CON_ID"
FROM V$XSTREAM_APPLY_RECEIVER