Integrated Replicat Hangs with State 'Waiting for memory' without Indexes at Target Database
(Doc ID 2554761.1)
Last updated on FEBRUARY 20, 2020
Applies to:Oracle GoldenGate - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Integrated Replicat hangs.
The following situations were seen.
1) Log Read Checkpoint was not moved.
REPLICAT <Replicat> Last Started 2019-05-29 17:52 Status RUNNING
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'.
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 (, Object=<schema>.<table>, , )
COUNT (Options=STOPKEY, , , )
TABLE ACCESS (Options=FULL, Object=<schema>.<table>, Type=TABLE, )
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