ORA-00055: maximum number of DML locks exceeded

ORA-00055: maximum number of DML locks exceeded

Cause: Ran out of DML lock state objects.

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

ORA-00055 maximum number of DML locks exceeded:

This tends to be an intermittent problem, and occurs at moments of peak usage in an Oracle database.

It can be resolved by changing a parameter in the "initSID.ora" file:

dml_locks = 200

Basically, if the DML Locks limit has been set at 200, then

. 200 people could each be updating one table at a time

· or 20 people could all be updating 10 tables at a time,

· or 1 user could be doing an account number rename and using 100 tables while 10 other people could be updating 10 tables.

These updates do not need to be the same table.

The number of locks required increased from Oracle8 onwards since partitioned tables would use a lock for each partition.

ORA-00060: deadlock detected while waiting for resource

ORA-00936:missing expression

ORA-02063 remote db error and how to fix it

ORA-00054: resource busy and acquire with NOWAIT specified

ORA-04091: table is mutating trigger

ORA-00604: error occurred at recursive SQL level string

PLS-00222: no function with name exists

ORA-00600: internal error code arguments:

ORA-21000:error number argument to raise_application_error is out of range

ORA-00257: archiver error. Connect internal only, until freed.

ORA-00001: unique constraint

ORA-00017: session requested to set trace event

ORA-00018: maximum number of sessions exceeded

ORA-00019: maximum number of session licenses exceeded

ORA-00020: maximum number of processes exceeded.

ORA-00021: session attached to some other process; cannot switch session

ORA-00022: invalid session ID; access denied

ORA-00023: session references process private memory; cannot detach session

ORA-00024: logins from more than one process not allowed in single-process mode

ORA-00025: failed to allocate string

ORA-00026: missing or invalid session ID

ORA-00027: cannot kill current session

ORA-00028: your session has been killed

ORA-00029: session is not a user session

ORA-00030: User session ID does not exist.

ORA-00054: resource busy and acquire with NOWAIT specified

ORA-00055: maximum number of DML locks exceeded

ORA-00060: deadlock detected while waiting for resource

ORA-00257: archiver error. Connect internal only, until freed.

ORA-00600: internal error code arguments

ORA-00604: error occurred at recursive SQL level string

ORA-00936:missing expression

ORA-00997: illegal use of LONG datatype

ORA-01000:maximum open cursors exceeded

ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces

ORA-01480: trailing null missing from STR bind value

ORA-01555: snapshot too old: rollback segment number string with name "string" too small

ORA-03237: Initial Extent of specified size cannot be allocated in tablespace

ORA-04030: out of process memory when trying to allocate string bytes

ORA-04031: unable to allocate string bytes of shared memory

ORA-04091: table is mutating trigger

ORA-12154: TNS:could not resolve the connect identifier specified - Oracle Error

ORA-21000:error number argument to raise_application_error is out of range

ORA-28009: connection to sys should be as sysdba or sysoper

PLS-00222: no function with name exists

ORA-01422: exact fetch returns more than requested number of rows

Share on Google Plus

About Mindsforest