

hi,
  
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*.

Tue, 15 Jul 2003 11:20:09 -0700
"Jenny -" <nat_lazy@hotmail.com>
locking mechanism