Oracle/PLSQL: ORA-04031 Error

Error:

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.

Action:

The options to resolve this Oracle error are:

Reduce your use of shared memory.
Increase the SHARED_POOL_SIZE initialization parameter in the initialization file.
Use the DBMS_SHARED_POOL package to pin large packages.