ROW Level Locking solved

From: Michael Kline <maklinesr_at_home.com>
Date: Sat, 9 Sep 2000 21:57:45 -0400
Message-Id: <10614.116592@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0009_01C01AA8.FC4FF3E0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Thanks to Steve Adams, and a few others, we found the PCTFREE was only 10%... We recreated the table with 40%... We got less rows(from 37 to 18), of course, but in testing we were able to lock each and every row separately from 18 separate sessions... One of those "strange" things since I normally use 60% used, 40% free when I create tables, and this one was basically built with TOAD from what I was told. Wasn't something I was looking for...

Now the customer will have several databases to be rebuilt, but they can concentrate on the tables that will actually get changes. Funny how it's those little things that "gotcha"... but that's where we come in.. :-)

Michael Kline
ThinkSpark
Richmond, VA
804-744-1545

------=_NextPart_000_0009_01C01AA8.FC4FF3E0 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=3D890023901-10092000><FONT face=3DArial size=3D2>Thanks =
to Steve=20
Adams, and a few others, we found the PCTFREE was only 10%... We = recreated the=20
table with 40%... We got less rows(from 37 to 18), of course, but in = testing we=20
were able to lock each and every row separately from 18 separate = sessions... One=20
of those "strange" things since I normally use 60% used, 40% free when I = create=20
tables, and this one was basically built with TOAD from what I was told. = Wasn't=20
something I was looking for... </FONT></SPAN></DIV>
<DIV><SPAN class=3D890023901-10092000><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D890023901-10092000><FONT face=3DArial size=3D2>Now =
the customer=20
will have several databases to be rebuilt, but they can concentrate on = the=20
tables that will actually get changes. Funny how it's those little = things that=20
"gotcha"... but that's where we come in.. :-)</FONT></SPAN></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><BR><FONT face=3D"Courier New">Michael =
Kline<BR>ThinkSpark<BR>Richmond,=20
VA<BR>804-744-1545<BR></FONT></DIV></BODY></HTML> Received on Sat Sep 09 2000 - 20:57:45 CDT