IR 'Waiting for memory' and hangs

(Doc ID 2202045.1)

Last updated on JANUARY 10, 2018

Applies to:

Oracle GoldenGate - Version 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;






Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms