Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> DML_LOCKS vs ENQUEUE_RESOURCES
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 Mon May 19 1997 - 00:00:00 CDT
![]() |
![]() |