maximum number of DML locks exceeded

Solution ID:ORA-00055

Type: Oracle

Cause

Ran out of DML lock state objects.

Actions

Increase the value of the DML_LOCKS initialization parameter and warm start.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e0.htm


http://docs.oracle.com/cd/E16655_01/timesten.121/e21636/awt_trouble.htm


https://community.oracle.com/message/9446075


https://community.oracle.com/message/2025568


https://community.oracle.com/message/4497062


https://community.oracle.com/message/1117811


https://community.oracle.com/message/1228927


Browse all solutions to database errors from Oracle, MS SQL, or MySQL