1)If the same PROCLOCK has some already-granted locks and
be waiting for more, how do we know?
I currently use the holding array of PROCLOCK to figure out what lockmodes a transaction(process) has been granted on LOCK,and if holdings sum comes to 0 that means this PROCLOCK is waiting for its associate LOCK. But how if the PROCLOCK has already been granted a lock and is waiting for another lock on the same object( LOCK), how do figure that out?
2)Is tuple level locks the same as row level locks?
Thanks!!
Jenny
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
