All apps dba Blog is the blog contributed by Doyensys Employees, With the view to share the knowledge out of their experience.
Doyensys Is a Fast Growing Oracle Technology Based Solutions Company Located in the US And Offshore Delivery Centers in India. With rich experience In Oracle E-Business, Oracle Database, Oracle Application Express (APEX), Oracle J Developer, Oracle OBIEE and E-Business Suite
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