ORA-04031 Unable To Allocate 720 Bytes of Shared Memory

 

The error ORA-04031 occurs on the shared pool which can indicate one of two things:

1) Insufficient space for the shared pool

OR

2) Although there is enough memory, it is fragmented and no contiguous chunk can be allocated to satisfy the latest memory request.

Solution:

Vineet Badre
Author: Vineet Badre

Leave a Reply

Your email address will not be published. Required fields are marked *