IR 'Waiting for memory' and hangs

(Doc ID 2202045.1)

Last updated on MARCH 28, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 and later
Information in this document applies to any platform.

Symptoms

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;

 

 

Changes

 None

Cause

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