ORA-12853, ORA-04031 and ORA-06512: at “SYS.UTL_RECOMP”, line 865

Those days I created a really small 11.2.0.4 database  with 4GB SGA_TARGET. 

ERROR at line 1: ORA-12801: error signaled in parallel query server P074, instance  XXXXXX:XXXXXXXX (3)

ORA-12853: insufficient memory for PX buffers: current 2676528K, max needed 11337360K

ORA-04031: unable to allocate 65560 bytes of shared memory ("largepool","unknown object","large pool","PX msg pool")

ORA-06512: at "SYS.UTL_RECOMP", line 865

ORA-06512: at line 4

While recompile the objects in database i had faced above errors even though when i tried multiple times same error i got. 

Solution :- 

SQL> show parameter parallel_max_servers

NAME                                 TYPE        VALUE

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

parallel_max_servers                 integer     970


Decrease the Value of parallel_max_servers to minimal as like below 

SQL> ALTER SYSTEM SET parallel_max_servers=30 SCOPE=BOTH;

System altered.

re run the Recompile script which will success next run.

SQL> @?/rdbms/admin/utlrp.sql