Goldengate Integrated Extract – Identifying and resolving extract process hang issue

By Ravi Karamsetty | January 2, 2016 |

Goldengate extract process can hang for various reasons. It is very important to have a process in place to monitor goldengate process and detect hanging issues. I recently encountered Goldengate Extract Hang issue. Below┬áis how I resolved this issue: Copy the following SQL and save to file – dba_capture_info.sql: col CAPTURE_NAME for a20; col QUEUE_NAME … Continue reading “Goldengate Integrated Extract – Identifying and resolving extract process hang issue”

Read More