Question on DML_LOCKS and ENQUEUE_RESOURCES

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