Application A holds an Exclusive lock on table TAB1 and needs to acquire an Exclusive lock on
table TAB2. Application B holds an Exclusive lock on table TAB2 and needs to acquire an
Exclusive lock on table TAB1. If lock timeout is set to -1 and both applications are using the Read
Stability isolation level, which of the following will occur?
A.
Applications A and B will cause a deadlock situation
B.
Application B will read the copy of table TAB1 that was loaded into memory when Application A
first read it
C.
Application B will read the data in table TAB1 and see uncommitted changes made by
Application A
D.
Application B will be placed in a lock-wait state until ApplicationA releases its lock
locktimeout – Lock timeout configuration parameter
This parameter specifies the number of seconds that an application will wait to obtain a lock, helping avoid global deadlocks for applications.
If you set this parameter to -1, lock timeout detection is turned off. In this situation a lock will be waited for (if one is not available at the time of the request) until either of the following:
The lock is granted
A deadlock occurs.
0
0