Re: chained rows and performance

From: Jared Still <jkstill_at_bcbso.com>
Date: Sun, 8 Oct 2000 10:32:46 -0700 (PDT)
Message-Id: <10643.118739@fatcity.com>

Have you analyzed the table? =20

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

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

What is the block size of the database?

What is the avg row size?

Jared

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

>=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

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Sun Oct 08 2000 - 12:32:46 CDT