My Oracle Support Banner

Integrated Replicat Hangs with State 'Waiting for memory' without Indexes at Target Database (Doc ID 2554761.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

Integrated Replicat hangs.
The following situations were seen.

1) Log Read Checkpoint was not moved.

GGSCI> INFO REPLICAT <Replicat> DETAIL

REPLICAT   <Replicat>  Last Started 2019-05-29 17:52   Status RUNNING
INTEGRATED
Checkpoint Lag       00:08:38 (updated 258:39:30 ago)
Process ID           69170
Log Read Checkpoint  File <GG_HOME>/dirdat/fd000000000
                    2019-05-19 21:22:03.952650  RBA 17474002


2) V$GG_APPLY_RECEIVER.STATE was 'Waiting for memory'.

SQL> select state from V$GG_APPLY_RECEIVER;

STATE
------------------
Waiting for memory

3) Increased max_sga_size to 2GB but the problem was not resolved.

4) GG related SQL: Statement (ASH) (<Document 1448324.1>) was delete statement and GG related SQL: Execution Plan was TABLE FULL SCAN.

DELETE STATEMENT  (n/a)                                               
 DELETE           (, Object=<schema>.<table>, , )                       
   COUNT           (Options=STOPKEY, , , )                             
     TABLE ACCESS  (Options=FULL, Object=<schema>.<table>, Type=TABLE, )

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.