LM_LOCKS (Oracle8 Only)
Values:512 to available shared memory
Default:12000
Multiple Instances:Must have the same value
Specifies the number of locks Oracle will configure for the lock manager when running Oracle Parallel Server. The number of locks can be expressed by the following equation:
L = R + (R × (N - 1))/N |
where:
L is the total number of locks.
R is the number of resources.
N is the total number of nodes.
Note that since lock configurations are per lock manager instance, this parameter must be the same for all lock manager instances.