Name

LM_LOCKS

Synopsis

Value: 512-available shared memory

Default: 12000

Specifies the number of locks that will be configured for the Lock Manager when running Parallel Server. The number of locks is represented by the following equation:

L = R + (R*(N - 1))/N

where:

R is the number of resources
N is the total number of nodes
L is the total number of locks

Multiple instances must have the same value. Obsolete with Oracle9i.

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.