12.1.0.2 : ORA-04030: ORA-04030: out of process memory when trying to allocate 254488 bytes(QERHJ ha

Hi ,

I would like to find the root cause of this error encountered after upgrade to 12.1.0.2.

pre_page_sga can be the culprit beacause default value has been changed from 11g to 12c ?

These are memory parameters :

SQL> show parameter sga

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

lock_sga                             boolean     FALSE

pre_page_sga                         boolean     TRUE

sga_max_size                         big integer 5G

sga_target                           big integer 3504M

unified_audit_sga_queue_size         integer     1048576

SQL> show parameter pga

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

pga_aggregate_limit                  big integer 13472M => 13 Go !

pga_aggregate_target                 big integer 1G

SQL> show parameter mem