Forum Stats

  • 3,853,728 Users
  • 2,264,259 Discussions
  • 7,905,436 Comments

Discussions

Open transaction deleted led to Extract process in recovery mode

807641
807641 Member Posts: 1
edited Dec 15, 2010 8:47AM in GoldenGate
Dear all,

I hit a problem which the application generates some long running transaction which over 4 hours. BRINTERVAL has set with default value 4 hours. So, now the extract processes are all in recovery mode and we can only wait for that. The long running transaction is by a delete statement which run over 4 hours in a batch job. So, how to handle for this case?

Regards,
George

Answers

This discussion has been closed.