Re: Question on DML_LOCKS and ENQUEUE_RESOURCES

Your reasoning is correct but it doesn't apply to dml_locks and enqueue_resources. DML_LOCKS actually refers to resources that are used for table locking. So the name for the parameter is a bit misleading.

K.J.K

Kelly Young wrote:

> We are in the process of installing Oracle Applications 10.7. The
> installation manual recommends setting the following initialization
> parameters:
> DML_LOCKS = 500
> ENQUEUE_RESOURCES = 5000
>
> To me, the value of these parameters should be reversed. DML_LOCKS
> is the grand total of locks on tables referenced by all users.
> ENQUEUE_RESOURCES is the number of resources (eg. tables) that can
> be locked by the lock manager. A resource can have multiple locks
> placed upon it; but a lock can be assigned to one, and only one,
> resource. Therefore, the number of DML_LOCKS should always be greater
> than ENQUEUE_RESOURCES.
>
> Is my reasoning correct?
> --
> Kelly Young
> Database Administrator
> Maricopa Community Colleges
> young_at_maricopa.edu
Received on Thu Dec 18 1997 - 00:00:00 CST