locking mechanism

<div style="background-color:"><div><div><div>hi,</div><div>  <p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span
style="FONT-SIZE:10pt; FONT-FAMILY: 'Courier New'">1)If the same PROCLOCK has some already-granted locks and</span><p
class="MsoNormal"style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><span
style="mso-spacerun:yes">    </span>be waiting for more, how do we know?</span><p class="MsoNormal" style="MARGIN: 0in
0in0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">  I currently use the holding array of PROCLOCK to
figureout what lockmodes a transaction(process) has been granted on LOCK,and if holdings sum comes to 0 that means this
PROCLOCKis waiting for its associate LOCK. But how if the PROCLOCK has already been granted a lock and is waiting for
anotherlock on the same object( LOCK), how do figure that out?</span><p class="MsoNormal" style="MARGIN: 0in 0in
0pt"><spanstyle="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"></span> <p class="MsoNormal" style="MARGIN: 0in 0in
0pt"><spanstyle="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">2)I<span style="FONT-SIZE: 12pt; COLOR: black;
FONT-FAMILY:'Times New Roman'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US;
mso-fareast-language:EN-US; mso-bidi-language: AR-SA">s tuple level locks the same as row level
locks?</span></span><spanstyle="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><span style="FONT-SIZE: 10pt; FONT-FAMILY:
'CourierNew'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US;
mso-bidi-language:AR-SA"></span></span><p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt;
FONT-FAMILY:'Courier New'"><span style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'; mso-fareast-font-family: 'Times
NewRoman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Thanks!!</span></span><p
class="MsoNormal"style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><span
style="FONT-SIZE:10pt; FONT-FAMILY: 'Courier New'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language:
EN-US;mso-fareast-language: EN-US; mso-bidi-language: AR-SA">Jenny</span> </span></div></div></div></div><br
clear="all"/><hr />Add photos to your e-mail with <a href="http://g.msn.com/8HMNENUS/2746??PS=">MSN 8.</a> Get 2 months
FREE*.