How to suppress "ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT" error in OGG Replicat

(Doc ID 2336885.1)

Last updated on JANUARY 04, 2018

Applies to:

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

Goal

OGG Replicat sometimes fails with one of the following errors in a rdbms 12c database

ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT) determining if column is virtual.

2017-11-25 15:23:20 ERROR OGG-00665 OCI Error describe for query (status = 39-ORA-00039: error during periodic action
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT), SQL<select status, deferrable from dba_constraints where owner =UPPER('OGG_PK') and table_name='TCUST' and constraint_type = 'P' >.

Solution

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