RE: Row Chaining: Yet to get answer

Message-Id: <10537.110295@fatcity.com> From: Alex Hillman Date: Fri, 23 Jun 2000 13:55:03 -0400 Subject: 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@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@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@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@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@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@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@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-printable RE: Row Chaining: Yet to get answer

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@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@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@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@oxhp.com

--
Author: Kimberly Smith
INET: kimberly.smith@gmd.fujitsu.com