There are times when too much locking can be a problem. This possibly can result in suspensions, timeouts, or even deadlocks. We will take a look at how these situations can occur.
While waiting for a lock, a process can exceed an allowable amount of wait time that has been established. A system-wide option determines the maximum time a process can wait before it gets a resource unavailable error. This value is called the resource timeout value and is calculated by the following formula:
Divide RESOURCE TIMEOUT by DEADLOCK TIME.
Round the result up to the next largest integer.
Multiply this integer by the DEADLOCK TIME.
Multiply the result by the appropriate factor.