ORA-04030 during ASCP data pull

Maran pinged me today for error during ASCP Data pull. The MSCPDPW module: Planning Data Pull Worker was erroring out with these errors:

Procedure LOAD_SALES_ORDER(2) started.
Error pulling data from MRP_AP2_SALES_ORDERS_V to MSC_ST_SALES_ORDERS.
ORA-04030: out of process memory when trying to allocate 2136 bytes (kxs-heap-c,qkkele)
ORA-02063: preceding line from ASCP2OLTP
ORA-04030: out of process memory when trying to allocate 2136 bytes (kxs-heap-c,qkkele)
ORA-02063: preceding line from ASCP2OLTP
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

I went through metalink note 233869.1 Diagnosing and Resolving ORA-4030 errors. The note is quite good and gives good insight. I also went through this presentation from Pythian Group titled Working with Automatic PGA, about which I found from Jonathan Lewis' site. The current setup in the instance was:

sga_max_size = 4G
sga_target = 3G
pga_aggregate_target=2G

I increased pga_aggregate_target=3G by

alter system set pga_aggregate_target=3G;

Data pull completed without issues after this change.
+---------------------------------------------------------------------------+
Executing request completion options...


Output is not being printed because:
The print option has been disabled for this report.


Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 10-JUN-2008 10:20:56

+---------------------------------------------------------------------------+
~