Specifies the amount of time, in seconds, the Oracle server waits for a lock to be released before generating an error when processing a Select...For Update statement on an Oracle 9i or higher server.
This connection option can affect performance.
Valid Values
-1 | 0 | x
where:
x
is an integer that specifies a number of seconds.
Behavior
If set to -1, the server waits indefinitely for the lock to be released.
If set to 0, the server generates an error immediately and does not wait for the lock to time out.
If set to x, the server waits for the specified number of seconds for the lock to be released.
Notes
If you are connected to an Oracle 8i server, any value greater than 0 is equivalent to the value -1.
If you are connected to an Oracle 8i server, any value greater than 0 is equivalent to the value -1.