Integer 

Static 

6000 

256 to a number limited by

• The shared memory available in the operating system,

• The maximum size of contiguous shared memory segment, or

• The address space.

You must set this parameter for every instance, and multiple instances must have the same value. 

LM_RESS controls the number of resources that can be locked by each lock manager instance. These resources include lock resources allocated for DML, DDL (data dictionary locks), data dictionary, and library cache locks plus the file and log management locks.

In most cases you should specify a value less than 2 * DML_LOCKS plus an overhead of about 20 locks.

See Also: Oracle8i Parallel Server Administration, Deployment, and Performance for more information on calculating an appropriate value for this parameter.