we are inserting records into the summary tables using imbedded SQL. When we try to delete the records using SQL*Plus, we get the
ORA-00055: maximum number of DML locks exceeded.
We shutdown and restarted the database and after some time the following errors came up:
ORA-01562: failed to extend rollback segment number 2
ORA-00604: error occurred at recursive SQL level 1
ORA-00055: maximum number of DML locks exceeded
I know I can increase the DML_LOCKS initialization parameter from the present 504 to an arbitrary higher figure, before I go into recalculating the actual requirement. I wanted to know whether increasing the dml_locks figure to a very high number will affect the database performance? Or it is immeterial and is acceptable?
My database is 8.1.6