Name

LM_LOCKS (Oracle8 Only)

Synopsis

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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset