Re: Default value for DML_LOCKS

On my system (Oracle 9.2 on AIX 5L), dml_locks is 748, and transactions is 187 (=748/4). None of these parameters is explicitly specified in the spfile. The default you state therefore seems to hold for me. What's your "transactions" value?

Daniel

> 8.1.7.0.0 on Windows Advanced 2000
>
> admin_at_DB4> show parameter dml_locks;
>
> NAME_COL_PLUS_SHOW_PARAM TYPE VALUE_COL_PLUS_SHOW_PARAM
> ------------------------------ ---------- ------------------------------
> dml_locks integer 576
>
>
> admin_at_DB4> select * from v$sgastat where name like 'DML%';
>
> POOL NAME BYTES
> ----------- -------------------------- ----------
> shared pool DML locks 69120
>
>
> dml_locks is not set in init.ora. How does Oracle determine the default
> value for dml_locks obtained above? According to Reference Manual, it is
> default to 4 * Transactions.
Received on Wed Jul 02 2003 - 11:18:15 CDT