DBA Data[Home] [Help]

VIEW: SYS.GV_$XSTREAM_OUTBOUND_SERVER

Source

View Text - Preformatted

select "INST_ID","SID","SERIAL#","SPID","SERVER_NAME","STARTUP_TIME","STATE","XIDUSN","XIDSLT","XIDSQN","COMMITSCN","TOTAL_TRANSACTIONS_SENT","MESSAGE_SEQUENCE","TOTAL_MESSAGES_SENT","SEND_TIME","LAST_SENT_MESSAGE_NUMBER","LAST_SENT_MESSAGE_CREATE_TIME","ELAPSED_SEND_TIME","COMMIT_POSITION","LAST_SENT_POSITION","BYTES_SENT","COMMITTED_DATA_ONLY","CON_ID" from gv$xstream_outbound_server
View Text - HTML Formatted

SELECT "INST_ID"
, "SID"
, "SERIAL#"
, "SPID"
, "SERVER_NAME"
, "STARTUP_TIME"
, "STATE"
, "XIDUSN"
, "XIDSLT"
, "XIDSQN"
, "COMMITSCN"
, "TOTAL_TRANSACTIONS_SENT"
, "MESSAGE_SEQUENCE"
, "TOTAL_MESSAGES_SENT"
, "SEND_TIME"
, "LAST_SENT_MESSAGE_NUMBER"
, "LAST_SENT_MESSAGE_CREATE_TIME"
, "ELAPSED_SEND_TIME"
, "COMMIT_POSITION"
, "LAST_SENT_POSITION"
, "BYTES_SENT"
, "COMMITTED_DATA_ONLY"
, "CON_ID"
FROM GV$XSTREAM_OUTBOUND_SERVER