VIEW: SYS._V$SXGG_APPLY_COORDINATOR

Source

View Text - Preformatted

select "SID","SERIAL#","STATE","APPLY#","APPLY_NAME","TOTAL_APPLIED","TOTAL_WAIT_DEPS","TOTAL_WAIT_COMMITS","TOTAL_ADMIN","TOTAL_ASSIGNED","TOTAL_RECEIVED","TOTAL_IGNORED","TOTAL_ROLLBACKS","TOTAL_ERRORS","UNASSIGNED_COMPLETE_TXNS","AUTO_TXN_BUFFER_SIZE","LWM_TIME","LWM_MESSAGE_NUMBER","LWM_MESSAGE_CREATE_TIME","HWM_TIME","HWM_MESSAGE_NUMBER","HWM_MESSAGE_CREATE_TIME","STARTUP_TIME","ELAPSED_SCHEDULE_TIME","ELAPSED_IDLE_TIME","LWM_POSITION","HWM_POSITION","PROCESSED_MESSAGE_NUMBER","CON_ID","ACTIVE_SERVER_COUNT" from v$streams_apply_coordinator
union all
select sid, serial#, state, apply#, apply_name, total_applied, total_wait_deps,
total_wait_commits, total_admin, total_assigned, total_received, total_ignored,
total_rollbacks, total_errors, unassigned_complete_txns, NULL, lwm_time,
lwm_message_number, lwm_message_create_time, hwm_time, hwm_message_number,
hwm_message_create_time, startup_time, elapsed_schedule_time,
elapsed_idle_time, lwm_position, hwm_position, processed_message_number,
con_id, active_server_count
from v$xstream_apply_coordinator
union all
select  sid, serial#, state, apply#, apply_name, total_applied, total_wait_deps,
total_wait_commits, total_admin, total_assigned, total_received, total_ignored,
total_rollbacks, total_errors, unassigned_complete_txns, NULL, lwm_time,
lwm_message_number, lwm_message_create_time, hwm_time, hwm_message_number,
hwm_message_create_time, startup_time, elapsed_schedule_time,
elapsed_idle_time, utl_raw.cast_to_raw(lwm_position),
utl_raw.cast_to_raw(hwm_position), processed_message_number, con_id,
active_server_count
from v$gg_apply_coordinator

View Text - HTML Formatted

SELECT "SID"
, "SERIAL#"
, "STATE"
, "APPLY#"
, "APPLY_NAME"
, "TOTAL_APPLIED"
, "TOTAL_WAIT_DEPS"
, "TOTAL_WAIT_COMMITS"
, "TOTAL_ADMIN"
, "TOTAL_ASSIGNED"
, "TOTAL_RECEIVED"
, "TOTAL_IGNORED"
, "TOTAL_ROLLBACKS"
, "TOTAL_ERRORS"
, "UNASSIGNED_COMPLETE_TXNS"
, "AUTO_TXN_BUFFER_SIZE"
, "LWM_TIME"
, "LWM_MESSAGE_NUMBER"
, "LWM_MESSAGE_CREATE_TIME"
, "HWM_TIME"
, "HWM_MESSAGE_NUMBER"
, "HWM_MESSAGE_CREATE_TIME"
, "STARTUP_TIME"
, "ELAPSED_SCHEDULE_TIME"
, "ELAPSED_IDLE_TIME"
, "LWM_POSITION"
, "HWM_POSITION"
, "PROCESSED_MESSAGE_NUMBER"
, "CON_ID"
, "ACTIVE_SERVER_COUNT"
FROM V$STREAMS_APPLY_COORDINATOR UNION ALL SELECT SID
, SERIAL#
, STATE
, APPLY#
, APPLY_NAME
, TOTAL_APPLIED
, TOTAL_WAIT_DEPS
, TOTAL_WAIT_COMMITS
, TOTAL_ADMIN
, TOTAL_ASSIGNED
, TOTAL_RECEIVED
, TOTAL_IGNORED
, TOTAL_ROLLBACKS
, TOTAL_ERRORS
, UNASSIGNED_COMPLETE_TXNS
, NULL
, LWM_TIME
, LWM_MESSAGE_NUMBER
, LWM_MESSAGE_CREATE_TIME
, HWM_TIME
, HWM_MESSAGE_NUMBER
, HWM_MESSAGE_CREATE_TIME
, STARTUP_TIME
, ELAPSED_SCHEDULE_TIME
, ELAPSED_IDLE_TIME
, LWM_POSITION
, HWM_POSITION
, PROCESSED_MESSAGE_NUMBER
, CON_ID
, ACTIVE_SERVER_COUNT FROM V$XSTREAM_APPLY_COORDINATOR UNION ALL SELECT SID
, SERIAL#
, STATE
, APPLY#
, APPLY_NAME
, TOTAL_APPLIED
, TOTAL_WAIT_DEPS
, TOTAL_WAIT_COMMITS
, TOTAL_ADMIN
, TOTAL_ASSIGNED
, TOTAL_RECEIVED
, TOTAL_IGNORED
, TOTAL_ROLLBACKS
, TOTAL_ERRORS
, UNASSIGNED_COMPLETE_TXNS
, NULL
, LWM_TIME
, LWM_MESSAGE_NUMBER
, LWM_MESSAGE_CREATE_TIME
, HWM_TIME
, HWM_MESSAGE_NUMBER
, HWM_MESSAGE_CREATE_TIME
, STARTUP_TIME
, ELAPSED_SCHEDULE_TIME
, ELAPSED_IDLE_TIME
, UTL_RAW.CAST_TO_RAW(LWM_POSITION)
, UTL_RAW.CAST_TO_RAW(HWM_POSITION)
, PROCESSED_MESSAGE_NUMBER
, CON_ID
, ACTIVE_SERVER_COUNT FROM V$GG_APPLY_COORDINATOR