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
  • January 15, 2017 | 13 views
  • Comments