Shipping Purge Completes With Error ORA-4036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
(Doc ID 2433505.1)
Last updated on FEBRUARY 20, 2019
Applies to:Oracle Shipping Execution - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Information in this document applies to any platform.
On : 12.1.3 version, Open Interfaces & Public APIs
Attempting to run Shipping Purge Concurrent Process, the following error occurs:
Unexpected error has occurred. Oracle error message is ORA-39: error during periodic action
ORA-4036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
The issue can be reproduced at will with the following steps:
1. Connect to Applications using an Order Management or Shipping Responsibility
2. Execute the Interface Shipping Purge Concurrent process
3. Process fails.
The current DB Parameters are set as recommended in the documentation (Limit is 2x Target)
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