Synopsis

Values:0 or 20 to unlimited

Default:4 × TRANSACTIONS

Multiple Instances:Must all have positive values or must all be 0

Specifies the maximum number of DML locks—one for each table modified in a transaction. The value should be set equal to the grand total of locks on all tables currently referenced by all users. For example, if five users are modifying data in one table, five entries would be required. If three users are modifying data in two tables, 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. Setting the value to disables enqueues and slightly increases performance. However, you cannot use DROP TABLE, CREATE INDEX, or explicit lock statements such as LOCK TABLE IN EXCLUSIVE MODE.