Hello
I have 3 replicat with large checkpoints, for more than 24 hours.
I try to see their status Sending STATUS request to REPLICAT REPX but I get the error ERROR OGG-15163 There was a problem sending a message to REPLICAT REPX (Timeout waiting for message).
I also kill the replicats and started one by one, waiting some time to see if the time decrease but it didn't happen.
I also went to the source of the extract and run send extract EXTAC2PR showtrans to see the open transactions.
For one of them, for example, I have two:
XID: 1813896886.4.14.97594
Items: 1
Extract: EXTX
Redo Thread: 1
Start Time: 2025-09-03T13:38:51.000Z
SCN: 3.1694442784 (14579344672)
Redo Seq: 25895
Redo RBA: 11143696
Status: Running
------------------------------------------------------------
XID: 1813896886.3.7.62318
Items: 1
Extract: EXTAX
Redo Thread: 1
Start Time: 2025-09-04T10:21:22.000Z
SCN: 3.1694697818 (14579599706)
Redo Seq: 25907
Redo RBA: 20795920
Status: Running
I have a lot of waits in the database checked by this query:
SELECT s.sid,
s.serial#,
s.username,
s.program,
s.module,
s.action,
s.status,
s.event,
s.seconds_in_wait
FROM v$session s
WHERE s.wait_class = 'Queueing'
AND s.event LIKE 'REPL Capture/Apply%'
13 ORDER BY s.seconds_in_wait DESC;
that gave the result as the 3 replicats. Before that I check for No locks or blocking sessions.
Can anynone help me get this replicat “unstuck”?
Thank you