My Oracle Support Banner

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 24, 2020

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='TABLE-NAME' and constraint_type = 'P' >.

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.