Answered Dead share lock

[Kartikeya Sharma]

Hi,

Do we have any command or statement to clear dead share lock.
or do we have any utility to find out each statement having which lock.

Thanks
Kartikeya Sharma

 

[TomBascom]

Perhaps you might explain what a "dead share lock" is and give an example showing how you know that you have one.

 

[Cringer]

Share locks of any kind are the result of bad code. Fix the code.

 

[Kartikeya Sharma]

Thanks all... yes code was wrote wrong... transaction scope was too big... we reduce transaction scope and share lock removed automatic.

 

[RealHeavyDude]

Unless you deliberately want to produce share-locks they usually come from the buffer scope being larger than the transaction scope. In such a scenario the exclusive lock is downgraded to a share lock.

Nevertheless, it's good you found it.