Re: Default value for DML_LOCKS

I kind found answer in Reference Manual.

dml_locks (defaults)

= 4 * transactions
= 4 * (1.1 * sessions)
= 4 * (1.1 * (1.1 * processes + 5))

I don't have transactions and sessions in init.ora, so dml_locks is dependant on processes.

• Jack

"Daniel Roy" <danielroy10junk_at_hotmail.com> wrote in message news:3722db.0307020818.22350140_at_posting.google.com...
> 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 - 15:33:41 CDT