Message-Id: <10612.116461@fatcity.com> From: "Michael Kline" Date: Thu, 7 Sep 2000 16:59:05 -0400 Subject: 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@ThinkSpark.com Pager: 877-705-1155 or 8777051155@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

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.

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

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.

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.

ThinkSpark - Michael Alan Kline,=20 Sr.

(formerly Database Consultants,=20 Inc.)
Technical Consultant - Richmond, Virginia=20 Office
13308 Thornridge Court; Midlothian, VA 23112, USA.
W: =20 804-744-1545
Michael.Kline@ThinkSpark.com=
Pager:=20 877-705-1155 or 8777051155@page.metrocall.c= om
ICQ:=20 1009605, 975313 PhoneFree: = 1057439