Re: Init. Parameter:DML_LOCKS

From Oracle 7.3 doc (no difference in 8.0 and 8i):

DML_LOCKS Default value:
derived (4 * TRANSACTIONS)

Range of values:
20 - unlimited, 0

Multiple instances:
must all have positive values or must all be 0

The maximum number of DML locks--one for each table modified in a transaction. Value should equal the grand total of locks on tables referenced by all users. For example, if 3 users are modifying data in one table, then 3 entries would be required. If 3 users are modifying data in 2 tables, then 6 entries would be required.

The default value assumes an average of 4 tables referenced per transaction. For some systems, this value may not be enough.

If the value is set 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. If the value is set to 0 on one instance, it must be set to 0 on all instances of an Oracle Parallel Server.

--
Have a nice day
Michel

Dennis <echome_at_ms16.hinet.net> a écrit dans le message : 87r9p2$glf$1_at_news.seed.net.tw...
> Dear all,
> Does anyone know what the init. paramter-DML_LOCKS is? The
> documents say it specifies the maximum number of DML locks. But when I set
> the values to 0, I still can use the DML statements such as update, insert
> or delete . How come? Thanks!
>
> Best Regards
> Dennis
>
>
>
>
Received on Wed Feb 09 2000 - 03:30:00 CST