Oracle Error ORA-04025: maximum allowed library object lock allocated for stringstringstringstringstring

Oracle Error Message

ORA-04025: maximum allowed library object lock allocated for stringstringstringstringstring

Reason for the Error

Too many active locks for the object has been allocated. This error can be a result of too many cursors kept open per session.

Solution

Close cursors, reduce session_cached_cursors value.