Hello Team,
We encounter this error on our database when compiling Package body :
ORA-04030: out of process memory when trying to allocate 311832 bytes (pga heap,control file i/o buffer)
ORA-04030: out of process memory when trying to allocate 16328 bytes (PLSQL Opt Pool,pdziM01_Create: New Set)
We have increased the PGA_AGGREGATE_TARGET from 8gb to 11GB but still error is encountered.
Our SGA_TARGET is 20GB
SQL> show parameter pga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_limit big integer 14106M
pga_aggregate_target big integer 11791213056
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean TRUE
sga_max_size big integer 19712M
sga_target big integer 19712M
unified_audit_sga_queue_size integer 1048576
We tried increasing sga_max_size to 30GB (*.sga_max_size=32212254720) but database was unable to start as show below
SQL> startup
ORA-27102: out of memory
SVR4 Error: 12: Not enough space
Additional information: 1671
Additional information: 16106127360
Additional information: 32195477504
Kindly assist us resolve.
thank you.