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:
1. Reduce your use of shared memory.
2. Increase the SHARED_POOL_SIZE initialization parameter in the initialization file.
3. Use the DBMS_SHARED_POOL package to pin large packages.
Error: ORA-04031: unable to allocate num
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:
1. Reduce your use of shared memory.
2. Increase the SHARED_POOL_SIZE initialization parameter in the initialization file.
3. Use the DBMS_SHARED_POOL package to pin large packages.