| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Row Chaining: Yet to get answer
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFDD3C.2858D170
Content-Type: text/plain;
charset="iso-8859-1"
Row migration happens usually not because of record is of type long but because it is not enougf free space in the block to keep updated record. It could happen if you have heavy updates or you have low prctfree and you need to increase it. Row chaining, on the other hand, happens when record is longer than (length of block) * (1-prctfree) and if it is more than lehgth of block it is impossible to prevent.
Alex Hillman
-----Original Message-----
From: Kimberly Smith [mailto:kimberly.smith_at_gmd.fujitsu.com]
Sent: Friday, June 23, 2000 2:16 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Row Chaining: Yet to get answer
You could potentially get row migration where the row is unable to it into one block completetly. Sometimes its impossible to avoid this due to longs and what not.
-----Original Message-----
Sanjeev
Sent: Friday, June 23, 2000 9:17 AM
To: Multiple recipients of list ORACLE-L
Logically there cannot be any row chaining. What u are seeing can be row
movement.
When oracle is not able to fit the record in the block it moves it enirely.
Or it may be from the initial records which u may have before bulk load.
-----Original Message-----
Sent: Friday, June 23, 2000 11:14 AM
To: Multiple recipients of list ORACLE-L
Hi gurus,
I asked to clear a doubt about row chaining, but have not rece'd any answer. I am asking again.
On a bulk Insert(and no update), will there be any row chaining at all? If yes, How to prevent it? If no, I have it although less than 1%.
Thanks in advance.
Sandeep
-- Author: Sandeep Dubey INET: sandeep.dubey_at_induscorp.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Author: Singla, Sanjeev INET: SSingla_at_oxhp.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Author: Kimberly Smith INET: kimberly.smith_at_gmd.fujitsu.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01BFDD3C.2858D170 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printableReceived on Fri Jun 23 2000 - 12:55:03 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: Row Chaining: Yet to get answer</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Row migration happens usually not because of record =
is of type long but because it is not enougf free space in the block to = keep updated record. It could happen if you have heavy updates or you = have low prctfree and you need to increase it. Row chaining, on the = other hand, happens when record is longer than (length of block) * = (1-prctfree) and if it is more than lehgth of block it is impossible to = prevent.</FONT></P>
<P><FONT SIZE=3D2>Alex Hillman</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Kimberly Smith [<A =
HREF=3D"mailto:kimberly.smith_at_gmd.fujitsu.com">mailto:kimberly.smith_at_gmd= .fujitsu.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Friday, June 23, 2000 2:16 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: RE: Row Chaining: Yet to get answer</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>You could potentially get row migration where the row =
is unable to</FONT>
<BR><FONT SIZE=3D2>it into one block completetly. Sometimes its =
impossible to avoid</FONT>
<BR><FONT SIZE=3D2>this due to longs and what not.</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>Sanjeev</FONT>
<BR><FONT SIZE=3D2>Sent: Friday, June 23, 2000 9:17 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Logically there cannot be any row chaining. What u =
are seeing can be row</FONT>
<BR><FONT SIZE=3D2>movement.</FONT>
<BR><FONT SIZE=3D2>When oracle is not able to fit the record in the =
block it moves it enirely.</FONT>
<BR><FONT SIZE=3D2>Or it may be from the initial records which u may =
have before bulk load.</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>Sent: Friday, June 23, 2000 11:14 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hi gurus,</FONT>
</P>
<P><FONT SIZE=3D2>I asked to clear a doubt about row chaining, but have =
not rece'd any answer.</FONT>
<BR><FONT SIZE=3D2>I am asking again.</FONT>
</P>
<P><FONT SIZE=3D2>On a bulk Insert(and no update), will there be any =
row chaining at all? If</FONT>
<BR><FONT SIZE=3D2>yes, How to prevent it? If no, I have it although =
less than 1%.</FONT>
</P>
<P><FONT SIZE=3D2>Thanks in advance.</FONT>
</P>
<P><FONT SIZE=3D2>Sandeep</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>--</FONT>
<BR><FONT SIZE=3D2>Author: Sandeep Dubey</FONT>
<BR><FONT SIZE=3D2> INET: sandeep.dubey_at_induscorp.com</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from). You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =
(like subscribing).</FONT>
<BR><FONT SIZE=3D2>--</FONT>
<BR><FONT SIZE=3D2>Author: Singla, Sanjeev</FONT>
<BR><FONT SIZE=3D2> INET: SSingla_at_oxhp.com</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from). You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =
(like subscribing).</FONT>
</P>
<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Kimberly Smith</FONT>
<BR><FONT SIZE=3D2> INET: kimberly.smith_at_gmd.fujitsu.com</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
 |
 |