Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DML_LOCKS vs ENQUEUE_RESOURCES

DML_LOCKS vs ENQUEUE_RESOURCES

From: Kelly Young <young_at_maricopa.edu>
Date: 1997/05/19
Message-ID: <3380BF17.1165@maricopa.edu>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US