We always see the similar WARNING in ggserr.log:
2024-07-14T20:33:15.697+1000 WARNING OGG-01027 Oracle GoldenGate Capture for Oracle, EXTDB.prm: Long Running Transaction: XID 3708191792.181.17.473582, Items 0, Extract EXTDB, Redo Thread 2, SCN 1447.4108855138 (6218926532450), Redo Seq #38608, Redo RBA 88457232.
Check the transaction in GGSCI:
GGSCI > send extract EXTDB, showtrans
OR show transactions lasting for more than 1200 minutes already.
GGSCI > send extract EXTDB, showtrans duration 1200 MIN TABULAR
Check the transaction in database:
SQL> select INST_ID,ADDR,XIDUSN,XIDSLOT,XIDSQN,STATUS,START_TIME,START_DATE from gv$transaction where XIDUSN=181 and XIDSLOT=17 and XIDSQN=473582;
INST_ID ADDR XIDUSN XIDSLOT XIDSQN STATUS START_TIME START_DATE
---------- ---------------- ---------- ---------- ---------- ---------------- -------------------- --------------------
2 000000021236DA28 181 17 473582 ACTIVE 07/05/24 18:37:56 07-May-2024 18:37:59
Skip the transaction:
GGSCI > send extract EXTDB,skiptrans 3708191792.181.17.473582
Sending SKIPTRANS request to EXTRACT EXTDB ...
Are you sure you sure you want to skip transaction XID 3708191792.181.17.473582, Redo Thread 2, Start Time 2024-05-07:18:37:56, SCN 1447.4108855138 (6218926532450)? (y/n)y
Sending SKIPTRANS request to EXTRACT EXTDB ...
Skiptrans operation successfully processed. Transaction XID 3708191792.181.17.473582, Redo Thread 2, Start Time 2024-05-07:18:37:56, SCN 1447.4108855138 (6218926532450) skipped
Make DBA Life Easy 