GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

REPL Capture/Apply: Memory

aoflima44Aug 27 2020 — edited Aug 29 2020

Does anybody know what this wait event is all about: "REPL Capture/Apply: memory"

My replicats are going so slow and this wait even is the only thing showing . 98% queuing.. there are 2 PDBs and 3 replicats.

SGA is 40G

stream_pool_size 6G

THanks for you help.

This post has been answered by ORASCN on Aug 29 2020

Jump to Answer

Sreesha Nair-Oracle

Hi,

This Wait event indicated that the Goldengate Integrated Processes are waiting for memory.

Make sure that streams_pool_size is appropriate to avoid Waiting For Memory issues.

Please try to increase the streams_pool_size at DB level and check if these waits are resolved.

6 GB seems to be a fairly good amount of memory for 3 processes unless there is a huge load

Have you set MAX_SGA_SIZE is replicat prm.This controls the amount of memory available to replicat, the default is INFINITE.

Also, check if replicats are trying to apply a huge transaction which is consuming all of the allocated memory.

If yes, check if you can use BATCHSQL to process the huge transaction.

Add the parameter to the replicat prm and restart

BATCHSQL BATCHTRANSOPS 10000, BYTESPERQUEUE 1000000000, BATCHERRORMODE

Or consider switching to parallel replicat which is designed to handle huge transactions in a more efficient manner.

1 person found this helpful

aoflima44

i did try to change to parallel replicat and got an error that the trail file version was not compatible.

source database is 11.2.0.4 and target is 19.3

ORASCN

Answer

Hi ,

Query the database view GV$APPLY_SERVER. Check the state of the Apply process. Is it waiting on memory or not.

Even though if you set the STREAMS_POOL_SIZE to 6GB, The Integrated Replicat process uses INFINITY by default. So, in order to control this, you need to use the parameter MAX_SGA_SIZE in the IR parameter file,

example

DBOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 3000)

The size is in MB.

Set this parameter in each Integrated Replicat process and check which replicat process is having issues. The replicat process might be processing a huge load and hence waiting for memory.

Please refer the below on how to set the memory when you use Integrated Capture/Apply.

https://www.oracle-scn.com/memory-requirement-for-oracle-goldengate-integrated-extract/

About Integrated Replicat

https://www.oracle-scn.com/oracle-goldengate-integrated-replicat/

About Parallel Replicat

https://www.oracle-scn.com/oracle-goldengate-parallel-replicat/

Regards,

Veera

Marked as Answer by aoflima44 · Sep 27 2020

1 person found this helpful

aoflima44

Thank you, this has resolved my issue.