ORA-00055: maximum number of DML locks exceeded

This forum is for Database developer ( PostgreSQL, MySQL, SQL Server, Oracle etc...) and database Administrator
alpeshviranik
Posts: 81
Joined: Thu Jul 17, 2014 4:58 pm
Contact:

ORA-00055: maximum number of DML locks exceeded

Postby alpeshviranik » Wed Aug 13, 2014 8:50 pm

if users get the error: ORA-00055 maximum number of DML locks exceeded
What is the problem and how to fix it?


Guest

Re: ORA-00055: maximum number of DML locks exceeded

Postby Guest » Wed Aug 13, 2014 8:53 pm

The number of DML Locks is set by the initialization parameter DML_LOCKS. If this value is set to low (which it is by default) you will get this error.
If you are sure that this is just a temporary problem, you can have them wait and then try again later and the error should clear.

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

It can be resolved by changing a parameter in the "initSID.ora" file:
dml_locks = 100
Basically, if the DML Locks limit has been set at 100, then
- 100 people could each be updating one table at a time
- 20 people could all be updating 5 tables at a time


Return to “PostgreSQL, MySQL, SQL Server, SQL,PL/SQL, TeraData Developer and DataBase Administration”

Who is online

Users browsing this forum: No registered users and 1 guest