Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Goldengate extract long running notification not coming

User_PHC09Feb 18 2021

Hi Experts,
Like to know when extract will give below notification for long running sessions.. some extract gives this notification and some just get stopped and go back to recovery to many days back while starting.

Sending STOP request to EXTRACT 
STOP request pending. There are open, long-running transactions.
Before you stop Extract, make the archives containing data for those transactions available for when Extract restarts.
To force Extract to stop, use the SEND EXTRACT , FORCESTOP command.

Is above notification still there in newer version of goldengate?. if yes when it will notify as i dont see it showing although there is many long running sessions.
i am aware like we need to check showtrans command and kill unwanted sessions and all before stopping extract . But still curious to know why the above notification is not working

Comments
Post Details
Added on Feb 18 2021
0 comments
607 views