11.2.0.4 on Linux: ORA-4030 when working with large PL/SQL-Collections

Hi all,

we work with Oracle 11.2.0.4 on RH-Linux  and on Windows.

Some of our PL/SQL Code uses big collections to transform data.

This Example shows the problem we have:

- 1 DB on RHEL, 1 on Windows

- on both DBs pga_aggregate_target=8G and sga_target=40G

- while running demo-code i monitor process-memory with

SELECT

  p.PROGRAM || ' [' || P.USERNAME || '] [' || (SELECT s.sid || '-' || s.serial# || '-' || nvl(s.username, 'N/A') FROM v$session s WHERE s.PADDR=p.ADDR) || ']' AS PROCESS,

  P.PGA_USED_MEM,

  P.PGA_ALLOC_MEM,

  P.PGA_FREEABLE_MEM,

  P.PGA_MAX_MEM