December 2002
Intermediate to advanced
928 pages
85h 29m
English
DML_LOCKS
Value: 0 | 20-unlimited
Default: 4 * TRANSACTIONS
Specifies the maximum number of DML locks; include one for each table modified in a transaction. The value should equal the grand total of locks on tables currently referenced by all users. If the value is set to 0, enqueues are disabled and performance is slightly increased. However, you will not be able to use DROP TABLE, CREATE INDEX, or explicit lock statements such as LOCK TABLE IN EXCLUSIVE MODE. Multiple instances must all have positive values or must all be 0.