Error: ORA-04031: unable to allocate 67280 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")
Cause: An ORA-04031 error occurs in any of the memory pools in the SGA when Oracle cannot find a memory chunk large enough to satisfy an internal allocation request on behalf of a user's operation.
Resolution: 1. Increased the SGA_TARGET value. 2. Changed cursor_sharing parameter to SIMILAR 3. Recommended using bind variables instead of literals.