select "INST_ID","COMPONENT_NAME","COMPONENT_TYPE","XIDUSN","XIDSLT","XIDSQN","BATCH_XIDUSN","BATCH_XIDSLT","BATCH_XIDSQN","CUMULATIVE_MESSAGE_COUNT","TOTAL_MESSAGE_COUNT","FIRST_MESSAGE_TIME","FIRST_MESSAGE_NUMBER","LAST_MESSAGE_TIME","LAST_MESSAGE_NUMBER","FIRST_MESSAGE_POSITION","LAST_MESSAGE_POSITION","TRANSACTION_ID","CON_ID" from gv$goldengate_transaction
SELECT "INST_ID"
, "COMPONENT_NAME"
, "COMPONENT_TYPE"
, "XIDUSN"
, "XIDSLT"
, "XIDSQN"
, "BATCH_XIDUSN"
, "BATCH_XIDSLT"
, "BATCH_XIDSQN"
, "CUMULATIVE_MESSAGE_COUNT"
, "TOTAL_MESSAGE_COUNT"
, "FIRST_MESSAGE_TIME"
, "FIRST_MESSAGE_NUMBER"
, "LAST_MESSAGE_TIME"
, "LAST_MESSAGE_NUMBER"
, "FIRST_MESSAGE_POSITION"
, "LAST_MESSAGE_POSITION"
, "TRANSACTION_ID"
, "CON_ID"
FROM GV$GOLDENGATE_TRANSACTION
|
|
|