IR 'Waiting for memory' and hangs
(Doc ID 2202045.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle GoldenGate - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Streams pool grows until IR crashes and stops responding to commands
Increasing streams pool does not help
++ Diagnostics ++
1. Connect to the database as SYSDBA
2. Monitor the Streams Pool usage with the following SQL statement
column BYTES format 999999999999
select INST_ID, POOL, NAME, BYTES from gv$sgastat where pool = 'streams pool' order by INST_ID , POOL, BYTES DESC;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document