Oracle / PLSQL: ORA-04031 Error Message

Learn the cause and how to resolve the ORA-04031 error message in Oracle.

Description

When you encounter an ORA-04031 error, the following error message will appear:

• ORA-04031: unable to allocate num bytes of shared memory num, num, num

Cause

You tried to use more shared memory than was available. SGA private memory has been exhausted.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

Reduce your use of shared memory.

Option #2

Increase the SHARED_POOL_SIZE initialization parameter in the initialization file.

Option #3

Use the DBMS_SHARED_POOL package to pin large packages.