Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DML_LOCKS vs ENQUEUE_RESOURCES
Hi Kelly,
I think your are confusing dml_locks with _enqueue_locks. It is the latter that establishes the size of x$ksqeq and must always be greater than enqueue resources.
Regards, Steve Adams
On Mon, 19 May 1997 13:59:03 -0700, Kelly Young <young_at_maricopa.edu> wrote:
>The installation manual for Applications 10.7 (as well as 10.5) for
>Unix recommends that the rdbms (7.3.2) initialization parameters
>DML_LOCKS be set to 500 and ENQUEUE_RESOURCES be set to 5000.
> Unless I completely misunderstand the function of these parameters,
>the values seem to be reversed. It is my understanding that a resource
>(e.g. table) can have multiple locks placed upon it; while a lock can be
>placed on one and only one resource. Given this, shouldn't the number
>of DML_LOCKS always be greater the ENQUEUE_RESOURCES? What am I
>missing?
Received on Sat May 24 1997 - 00:00:00 CDT