VIEW: SYS._V$SXGG_APPLY_SERVER

Source

View Text - Preformatted

select "SID","SERIAL#","APPLY#","APPLY_NAME","SERVER_ID","STATE","XIDUSN","XIDSLT","XIDSQN","COMMITSCN","DEP_XIDUSN","DEP_XIDSLT","DEP_XIDSQN","DEP_COMMITSCN","MESSAGE_SEQUENCE","TOTAL_ASSIGNED","TOTAL_ADMIN","TOTAL_ROLLBACKS","TOTAL_MESSAGES_APPLIED","APPLY_TIME","APPLIED_MESSAGE_NUMBER","APPLIED_MESSAGE_CREATE_TIME","ELAPSED_DEQUEUE_TIME","ELAPSED_APPLY_TIME","COMMIT_POSITION","DEP_COMMIT_POSITION","LAST_APPLY_POSITION","TRANSACTION_ID","DEP_TRANSACTION_ID","CON_ID","TOTAL_LCRS_RETRIED","LCR_RETRY_ITERATION","TOTAL_TXNS_RETRIED","TXN_RETRY_ITERATION","TOTAL_TXNS_RECORDED" from v$streams_apply_server union all
select "SID","SERIAL#","APPLY#","APPLY_NAME","SERVER_ID","STATE","XIDUSN","XIDSLT","XIDSQN","COMMITSCN","DEP_XIDUSN","DEP_XIDSLT","DEP_XIDSQN","DEP_COMMITSCN","MESSAGE_SEQUENCE","TOTAL_ASSIGNED","TOTAL_ADMIN","TOTAL_ROLLBACKS","TOTAL_MESSAGES_APPLIED","APPLY_TIME","APPLIED_MESSAGE_NUMBER","APPLIED_MESSAGE_CREATE_TIME","ELAPSED_DEQUEUE_TIME","ELAPSED_APPLY_TIME","COMMIT_POSITION","DEP_COMMIT_POSITION","LAST_APPLY_POSITION","TRANSACTION_ID","DEP_TRANSACTION_ID","CON_ID","TOTAL_LCRS_RETRIED","LCR_RETRY_ITERATION","TOTAL_TXNS_RETRIED","TXN_RETRY_ITERATION","TOTAL_TXNS_RECORDED" from v$xstream_apply_server union all
select sid, serial#, apply#, apply_name, server_id, state, xidusn, xidslt, xidsqn,
commitscn, dep_xidusn, dep_xidslt, dep_xidsqn, dep_commitscn, message_sequence,
total_assigned, total_admin, total_rollbacks, total_messages_applied, apply_time,
NULL, NULL, NULL,
elapsed_apply_time, utl_raw.cast_to_raw(commit_position),
utl_raw.cast_to_raw(dep_commit_position),
utl_raw.cast_to_raw(last_apply_position),
transaction_id, dep_transaction_id, con_id, total_lcrs_retried, lcr_retry_iteration,
total_txns_retried, txn_retry_iteration, total_txns_recorded from v$gg_apply_server

View Text - HTML Formatted

SELECT "SID"
, "SERIAL#"
, "APPLY#"
, "APPLY_NAME"
, "SERVER_ID"
, "STATE"
, "XIDUSN"
, "XIDSLT"
, "XIDSQN"
, "COMMITSCN"
, "DEP_XIDUSN"
, "DEP_XIDSLT"
, "DEP_XIDSQN"
, "DEP_COMMITSCN"
, "MESSAGE_SEQUENCE"
, "TOTAL_ASSIGNED"
, "TOTAL_ADMIN"
, "TOTAL_ROLLBACKS"
, "TOTAL_MESSAGES_APPLIED"
, "APPLY_TIME"
, "APPLIED_MESSAGE_NUMBER"
, "APPLIED_MESSAGE_CREATE_TIME"
, "ELAPSED_DEQUEUE_TIME"
, "ELAPSED_APPLY_TIME"
, "COMMIT_POSITION"
, "DEP_COMMIT_POSITION"
, "LAST_APPLY_POSITION"
, "TRANSACTION_ID"
, "DEP_TRANSACTION_ID"
, "CON_ID"
, "TOTAL_LCRS_RETRIED"
, "LCR_RETRY_ITERATION"
, "TOTAL_TXNS_RETRIED"
, "TXN_RETRY_ITERATION"
, "TOTAL_TXNS_RECORDED"
FROM V$STREAMS_APPLY_SERVER UNION ALL SELECT "SID"
, "SERIAL#"
, "APPLY#"
, "APPLY_NAME"
, "SERVER_ID"
, "STATE"
, "XIDUSN"
, "XIDSLT"
, "XIDSQN"
, "COMMITSCN"
, "DEP_XIDUSN"
, "DEP_XIDSLT"
, "DEP_XIDSQN"
, "DEP_COMMITSCN"
, "MESSAGE_SEQUENCE"
, "TOTAL_ASSIGNED"
, "TOTAL_ADMIN"
, "TOTAL_ROLLBACKS"
, "TOTAL_MESSAGES_APPLIED"
, "APPLY_TIME"
, "APPLIED_MESSAGE_NUMBER"
, "APPLIED_MESSAGE_CREATE_TIME"
, "ELAPSED_DEQUEUE_TIME"
, "ELAPSED_APPLY_TIME"
, "COMMIT_POSITION"
, "DEP_COMMIT_POSITION"
, "LAST_APPLY_POSITION"
, "TRANSACTION_ID"
, "DEP_TRANSACTION_ID"
, "CON_ID"
, "TOTAL_LCRS_RETRIED"
, "LCR_RETRY_ITERATION"
, "TOTAL_TXNS_RETRIED"
, "TXN_RETRY_ITERATION"
, "TOTAL_TXNS_RECORDED"
FROM V$XSTREAM_APPLY_SERVER UNION ALL SELECT SID
, SERIAL#
, APPLY#
, APPLY_NAME
, SERVER_ID
, STATE
, XIDUSN
, XIDSLT
, XIDSQN
, COMMITSCN
, DEP_XIDUSN
, DEP_XIDSLT
, DEP_XIDSQN
, DEP_COMMITSCN
, MESSAGE_SEQUENCE
, TOTAL_ASSIGNED
, TOTAL_ADMIN
, TOTAL_ROLLBACKS
, TOTAL_MESSAGES_APPLIED
, APPLY_TIME
, NULL
, NULL
, NULL
, ELAPSED_APPLY_TIME
, UTL_RAW.CAST_TO_RAW(COMMIT_POSITION)
, UTL_RAW.CAST_TO_RAW(DEP_COMMIT_POSITION)
, UTL_RAW.CAST_TO_RAW(LAST_APPLY_POSITION)
, TRANSACTION_ID
, DEP_TRANSACTION_ID
, CON_ID
, TOTAL_LCRS_RETRIED
, LCR_RETRY_ITERATION
, TOTAL_TXNS_RETRIED
, TXN_RETRY_ITERATION
, TOTAL_TXNS_RECORDED
FROM V$GG_APPLY_SERVER