Initialization Parameters, 45 of 188

DML_LOCKS

Parameter type:
Integer

Parameter class:
Static

Default value:
Derived: (4 * TRANSACTIONS)

Range of values:
20 to unlimited. A setting of 0 disables enqueues.

Oracle Parallel Server:
You must set this parameter for every instance, and all instances must have positive values or all must be 0.

A DML lock is a lock obtained on a table that is undergoing a DML operation (insert, update, delete). DML_LOCKS specifies the maximum number of DML locks--one for each table modified in a transaction. The value should equal the grand total of locks on tables currently referenced by all users. For example, if three users are modifying data in one table, then three entries would be required. If three users are modifying data in two tables, then six entries would be required.
The default value assumes an average of four tables referenced per transaction. For some systems, this value may not be enough.
Enqueues are shared memory structures that serialize access to database resources. If you set the value of DML_LOCKS to 0, enqueues are disabled and performance is slightly increased. However, you cannot use DROP TABLE, CREATE INDEX, or explicit lock statements such as LOCK TABLE IN EXCLUSIVE MODE.

Oracle holds more locks during parallel DML than during serial execution. Therefore, if your database supports a lot of parallel DML, you may need to increase the value of this parameter. See Also:

Oracle8i Concepts for a discussion of lock and enqueue resources needed for parallel DML.

Oracle8i Parallel Server Administration, Deployment, and Performance, Oracle8i Concepts, and Oracle8i Distributed Database Systems for more information on data concurrency.

Parameter type:	Integer
Parameter class:	Static
Default value:	Derived: (4 * `TRANSACTIONS)`
Range of values:	20 to unlimited. A setting of 0 disables enqueues.
Oracle Parallel Server:	You must set this parameter for every instance, and all instances must have positive values or all must be 0.
A DML lock is a lock obtained on a table that is undergoing a DML operation (insert, update, delete). `DML_LOCKS` specifies the maximum number of DML locks--one for each table modified in a transaction. The value should equal the grand total of locks on tables currently referenced by all users. For example, if three users are modifying data in one table, then three entries would be required. If three users are modifying data in two tables, then six entries would be required. The default value assumes an average of four tables referenced per transaction. For some systems, this value may not be enough. Enqueues are shared memory structures that serialize access to database resources. If you set the value of `DML_LOCKS` to 0, enqueues are disabled and performance is slightly increased. However, you cannot use `DROP` `TABLE`, `CREATE` `INDEX`, or explicit lock statements such as `LOCK` `TABLE` `IN` `EXCLUSIVE` `MODE`.
Oracle holds more locks during parallel DML than during serial execution. Therefore, if your database supports a lot of parallel DML, you may need to increase the value of this parameter. See Also: Oracle8i Concepts for a discussion of lock and enqueue resources needed for parallel DML. Oracle8i Parallel Server Administration, Deployment, and Performance, Oracle8i Concepts, and Oracle8i Distributed Database Systems for more information on data concurrency.