Initialization Parameters, 74 of 188

LM_LOCKS

Parameter type:	Integer
Parameter class:	Static
Default value:	12000
Range of values:	512 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.
Oracle Parallel Server:	You must set this parameter for every instance, and multiple instances must have the same value.
LM_LOCKS is an Oracle Parallel Server parameter that specifies the number of locks that will be configured for the lock manager. The number of locks can be represented by the following equation: L = R + (R*(N - 1))/N where `L` = the total number of locks `R` = the number of resources (as determined by the `LM_RESS` parameter). See "LM_RESS". `N` = the total number of nodes
Oracle configures locks per lock manager instance. Thus the value of `LM_LOCKS` must be the same for all lock manager instances. With DBA locking, up to 2 * `GC_RELEASABLE_LOCKS` could be required, at most.
See Also: Oracle8i Parallel Server Administration, Deployment, and Performance for more information on setting this parameter.