My Oracle Support Banner

Integrated Extract MEMORY LEAK with ORA-4030: slow or abend (Doc ID 2176646.1)

Last updated on JUNE 05, 2019

Applies to:

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

Symptoms

Integrated extract is slow when doing fetching

another symptom is abend when doing the fetching:


2016-05-09 06:58:31 ERROR OGG-06534 Reporting diagnostic information for unexpected fetching error.
Table Name <schema>.<table>, Object Type 2, Object ID 463240, Sequence #0, RBA 0, SCN 0, xid 706.24.1469.

in both cases, ora-4030 is seen in alert:

ORA-04030: out of process memory when trying to allocate 169040 bytes (pga heap,kgh stack)
ORA-04030: out of process memory when trying to allocate 55600 bytes (qmcxdDecodeIni,qmemNextBuf:Large Alloc)

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
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.