SOURCEISTABLE Extract Is Consuming All Memory On System, O/s Is Killing The Process (Doc ID 2226993.1)

Last updated on APRIL 19, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.1 to 12.2.0.1.0 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

Using GG version 12.2.0.1.0 for MySQL, running on a RHEL 6 Linux x86_64 bit platform, extract uses a large amount of storage and then terminates before it completes.

Memory steady state before start of extract...
[svc_ggs@qa-laxpower-db-01w ggs]$ free -h
  total used free shared buffers cached
Mem: 7.7G 2.5G 5.2G 16K 12M 57M
-/+ buffers/cache: 2.4G 5.3G
Swap: 1.0G 1.0G 12K

Memory while SOURCEISTABLE extract is running just before it is killed...
[svc_ggs@qa-laxpower-db-01w ggs]$ free -h
  total used free shared buffers cached
Mem: 7.7G 7.5G 152M 16K 12M 45M
-/+ buffers/cache: 7.5G 211M
Swap: 1.0G 1.0G 0B

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