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