| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> More on that strange locking we have
This is a multi-part message in MIME format.
------=_NextPart_000_0022_01C018EC.EE1B7820 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
We are now listing records by row id so we can tell which records are in the same blocks. We have 'some" consistency on the problem.
If we pick up a single block and we lock record 1, then 2, then 3, the forth lock fails. If we lock record 1, then 16, then 23, we can't lock 26.... Again the fourth one.
But it appears we can lock much more than that, if they are on different blocks. There is approximately 35 records per block.
I found rollback segments to be low, so I added about 8 more, and they are doing more testing. Haven't heard back so far.
ThinkSpark - Michael Alan Kline, Sr.
(formerly Database Consultants, Inc.)
Technical Consultant - Richmond, Virginia Office
13308 Thornridge Court; Midlothian, VA 23112, USA.
W: 804-744-1545
Michael.Kline_at_ThinkSpark.com
Pager: 877-705-1155 or 8777051155_at_page.metrocall.com
ICQ: 1009605, 975313 PhoneFree: 1057439
------=_NextPart_000_0022_01C018EC.EE1B7820 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4207.2601" name=3DGENERATOR></HEAD>
<BODY bgColor=3D#ffffff>
<DIV><SPAN class=3D200325520-07092000><FONT face=3DArial size=3D2>We are =
now listing=20
records by row id so we can tell which records are in the same blocks. =
We have=20
'some" consistency on the problem.</FONT></SPAN></DIV>
<DIV><SPAN class=3D200325520-07092000><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D200325520-07092000><FONT face=3DArial size=3D2>If we =
pick up a=20
single block and we lock record 1, then 2, then 3, the forth lock fails. =
If we=20
lock record 1, then 16, then 23, we can't lock 26.... Again the fourth =
one.=20
</FONT></SPAN></DIV>
<DIV><SPAN class=3D200325520-07092000><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D200325520-07092000><FONT face=3DArial size=3D2>But it =
appears we=20
can lock much more than that, if they are on different blocks. There is=20
approximately 35 records per block.</FONT></SPAN></DIV>
<DIV><SPAN class=3D200325520-07092000><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D200325520-07092000><FONT face=3DArial size=3D2>I =
found rollback=20
segments to be low, so I added about 8 more, and they are doing more =
testing.=20
Haven't heard back so far.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2><FONT face=3D"Times New Roman"><FONT size=3D2><FONT=20
size=3D3><STRONG>ThinkSpark </STRONG></FONT> - Michael Alan Kline,=20
Sr.</FONT></FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT face=3D"Times New Roman"><FONT size=3D2><FONT=20
face=3DArial><FONT size=3D1>(formerly Database Consultants,=20
Inc.)</FONT></FONT><BR>Technical Consultant - Richmond, Virginia=20
Office<BR>13308 Thornridge Court; Midlothian, VA 23112, USA.<BR><SPAN=20
class=3D470475317-20121999><FONT face=3D"">W: =20
804-744-1545</FONT></SPAN><BR><A=20
href=3D"mailto:Michael.Kline_at_ThinkSpark.com">Michael.Kline_at_ThinkSpark.com=
</A><BR>Pager:=20
877-705-1155 or <A=20
href=3D"mailto:8777051155_at_page.metrocall.com">8777051155_at_page.metrocall.c=
om</A><BR>ICQ:=20
1009605, 975313 PhoneFree: =
1057439</FONT></FONT></FONT></DIV>
Received on Thu Sep 07 2000 - 15:59:05 CDT
 |
 |