Oracle DBA, How To, Error, Cause and Action

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

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


Cause:


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



Action:


Close cursors, reduce session_cached_cursors value.

No comments:

Post a Comment

Thanks for your comment.