Default value for DML_LOCKS

From: Jack <nospam_at_nospam.com>
Date: Wed, 02 Jul 2003 05:53:41 GMT
Message-ID: <FruMa.27466$ZS3.2643360@news2.telusplanet.net>

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 - 00:53:41 CDT