What makes this message so fascinating is what it implies: Orderly termination . In enterprise software, "orderly" is a luxury. We have become accustomed to the abruptness of kill -9 , the mystery of core dumps, and the apology of a "Segmentation Fault." We live in a world where applications hang on "Shutting down..." for twenty minutes.
When this detachment occurs, the EXTRACT process will often end ( ABEND ) because it can no longer pull data. Common Causes for Detachment
In these scenarios, the detachment ensures that System Global Area (SGA) memory is freed and that the database doesn't keep a "zombie" capture session active, which could prevent the deletion of old archived logs. When It’s a Problem What makes this message so fascinating is what
Expected behavior if you intentionally set IDLETIMEOUT . Verify your design.
| Pitfall | Solution | |---------|----------| | Detaching while transactions are open | Stop client gracefully first | | Forgetting to reattach | Document maintenance windows | | No backup of checkpoint | Use INFO CAPTURE ... SHOWCHECKPOINTS before detach | | Microservices: orphaned clients | Use DELETE CAPTURE if reattach fails | When this detachment occurs, the EXTRACT process will
To understand this message, we must look at the architecture of Oracle GoldenGate, particularly when using mode.
SELECT component, current_size/1024/1024 AS size_mb FROM v$sga_dynamic_components WHERE component = 'streams pool'; Use code with caution. Verify your design
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.
To check the current status or restart the process, use these commands in the GGSCI or Admin Client console: STATUS EXTRACT Start process: START EXTRACT View logs: VIEW REPORT 💡 Best Practices
It confirms that the database resources used by the capture process (memory in the STREAMS_POOL , background processes) have been released. 2. Common Causes for Detachment