Is there any initialization parameter or sth similar who tell me
how long connection wait for requested lock ( row lock or table lock) if object is alredy locked by other connection?
Also,is there any server cfg parameter or sth similar who tell me
interval for checking deadlocks?
I read that "deadlock situation can be released even after waiting
for few minutes"! That seems me too too much,I think everything bigger than seven seconds is unsatisfatory...
In one word,is DBA can do anything (by parms,for example) about waiting for locks or releasing deadlocks situation?
Any help will be great,
P.S. MetaLink tell me nothing about that,i'm afraid