Kirsten,
just compute length of the row and compare it with block size. If the =
length
is greater than block size then you have chained row
=FC=C4
> =20
> =20
> Chuck,
> =20
> How can I determine if these are chained or migrated rows ???
> =20
> Greets,
> =20
> Kirsten
> =20
> > -----Original Message-----
> > From: Chuck Hamilton [SMTP:chuck_hamilton_at_yahoo.com]
> > Sent: Tuesday, October 10, 2000 7:20 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Performance - Chained Rows
> >=20
> > Absolutely. You first need to determine whether these are=20
> true chained
> > rows or migrated rows. Both show up in the chain_cnt=20
> column of dba_tables.
> > If they are migrated rows (most likely), increase the=20
> PCTFREE for the
> > table, and reorg it. If they are true chained rows and the=20
> table contains
> > LOBs, store the LOBs in a separate lob segment. If they're=20
> chained rows
> > and you're not using LOBs your choices are to increase the=20
> block size to
> > something large enough to accomodate the largest row, or=20
> live with it. Be
> > advised that changing the block size requires recreating=20
> the database.=20
> >=20
> >=20
> > "Weerd Kirsten, E.C. de" <Kirsten.deWeerd_at_Oranjewoud.nl> wrote:=20
> >=20
> >=20
> >=20
> > Hi,
> > =09
> > I'm still looking for a cause of performance problems ...
> > =09
> > I have found a table, very frequently used in forms and=20
> procedures,
> > with about 10% chained rows. Other most frequently used=20
> tables have
> > about
> > 0,3 % chained rows. Could this be an issue ???
> > =09
> > Greets,
> > =09
> > Kirsten
> > --=20
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --=20
> > Author: Weerd Kirsten, E.C. de
> > INET: Kirsten.deWeerd_at_Oranjewoud.nl
> > =09
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > =09
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an=20
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of=20
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you wan! ! t to be removed=20
> from). You
> > may
> > also send the HELP command for other information (like=20
> subscribing).
> >=20
> >=20
> >=20
> > _____ =20
> >=20
> > Do You Yahoo!?
> > Get Yahoo! Mail <http://mail.yahoo.com/> - Free email you=20
> can access from
> > anywhere!
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Weerd Kirsten, E.C. de
> INET: Kirsten.deWeerd_at_Oranjewoud.nl
> =20
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access /=20
> 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
Received on Thu Oct 12 2000 - 04:54:06 CDT
