skip to main content
Connection Option Descriptions : Lock Timeout
  

Try DataDirect Drivers Now

Lock Timeout

Attribute

LockTimeout (LTO)

Purpose

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

*This connection option can affect performance.

Default

-1

GUI Tab

Performance tab

See also

Performance Considerations