December 2002
Intermediate to advanced
928 pages
85h 29m
English
ENQUEUE_RESOURCES
Value: 10-unlimited
Default: Derived from SESSIONS
Sets the number of resources that can be concurrently locked by the Lock Manager. For fewer than 4 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. If ENQUEUE_RESOURCES is explicitly set to a value higher than DML_LOCKS + 20, then the value provided is used. If there are many tables, the value may be increased. Allow one per resource, regardless of the number of sessions or cursors using that resource. Increase the value if Oracle returns an error specifying that enqueues are exhausted.