Synopsis

Values:10 to 65535

Default:Derived from the SESSIONS parameter

Specifies the number of resources that can be locked concurrently by the lock manager. The default value of this parameter is derived from the SESSIONS parameter. For three or fewer sessions, the default value is 20; for 4 to 10 sessions, the default value is ((SESSIONS - 3) × 5) + 20; and for more than 10 sessions, it is ((SESSIONS - 10) × 2) + 55. These values should be adequate as long as DML_LOCKS + 20 is less than ENQUEUE_RESOURCES. If this parameter is explicitly set to a value higher than DML_LOCKS + 20, the value provided is used. If there are many tables, the value may be increased by 1 for each resource added (regardless of the number of sessions or cursors using that resource), not by 1 for each lock. You should only increase this parameter if Oracle returns an error specifying that enqueues are exhausted.