
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 MSN 8 helps ELIMINATE E-MAIL VIRUSES. Get 2 months FREE*.

Sun, 13 Jul 2003 10:17:25 -0700
"Jenny -" <nat_lazy@hotmail.com>
locking mechanism