DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Sunday, January 15, 2017

ORA-00055: Maximum Number of DML locks exceeded

The number of DML Locks is set by the initialization parameter DML_LOCKS.
This value will be by default set to small value and results in the error. Increase the value of DML_LOCKS.
Sometimes the issue occurs at peak usage of database.
Change in the parameter file (initSID.ora) For Example: dml_locks = 200

No comments: