When running on MTP, received the following:
Received: Error: "Unexpected Oracle error: ORA-04030: out of process memory" when trying to allocate xxx bytes
MTP needs more memory than what is allocated.
1. Check the v$pgastat;
2. Run the top command, and check the swap space and memory usage
1. Increase the PGA_AGGREGATE_TARGET in the database
alter system set PGA_AGGREGATE_TARGET= xxx;
2. Increase swap space