Re: chained rows and performance

From: Ari D Kaplan <akaplan_at_interaccess.com>
Date: Sun, 8 Oct 2000 12:43:46 -0500 (CDT)
Message-Id: <10643.118740@fatcity.com>

Also, what is your PCTUSED / PCTFREE? This, along with the block size and avg row length, contributes to row chaining. Another possibility is if you have a LONG column ; the LONG data is stored with the record. With LOBs you can store the LOB separate from the rest of the record.

What caused the chaining? Frequent updates, where the updated record is larger in size? Frequent deletes/inserts with a poorly sized PCTUSED / PCTFREE? -Ari Kaplan
www.arikaplan.com

On Sun, 8 Oct 2000, Jared Still wrote:

>=20

> Have you analyzed the table? =20

>=20

> If so, what is the ratio of chained rows
> as seen in DBA_TABLES?

>=20

> When you say 'poor performance', what exactly
> are you referring to? SELECT's?=20

>=20

> What is the block size of the database?

>=20

> What is the avg row size?

>=20

> Jared

>=20

> On Sun, 8 Oct 2000 lack_at_baq-bayern.de wrote:

>=20


> >=20

> > Hello,

> >=20

> > i'm getting very poor performance which i suspect is due to a high

> > number of chained rows appearing after trying to insert data into a

> > large number of columns of an existing table while using a cursor loop.

> >=20

> > can anyone help me?

> >=20

> > Thanks,

> >=20

> > Regards,

> >=20

> > Nick

> >=20

> >=20

> >=20

> > Mit freundlichen Gr=FCssen

> > Nicholas Lack

> >=20

> > Bayerische

> > Arbeitsgemeinschaft f=FCr Qualit=E4tssicherung

> > in der station=E4ren Versorgung

> > Westenriederstr. 19

> >=20

> > 80331 M=FCnchen

> >=20

> > TEL.: 089 21159012

> > FAX : +49 89 21159019

> >=20
> >=20

>=20
>=20

> Jared Still
> Certified Oracle DBA and Part Time Perl Evangelist ;-)
> Regence BlueCross BlueShield of Oregon
> jkstill_at_bcbso.com - Work - preferred address
> jkstill_at_teleport.com - private

>=20
>=20

> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_bcbso.com

>=20


> 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
Received on Sun Oct 08 2000 - 12:43:46 CDT