Integrated Extract MEMORY LEAK with ORA-4030: slow or abend
Last updated on JANUARY 25, 2018
Applies to:Oracle GoldenGate - Version 188.8.131.52.5 and later
Information in this document applies to any platform.
Integrated extract is slow hen 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 PMTS_HUB_OWNER.MINF, 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)
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