Re: Chained Rows VS new extent allocation

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Tue, 28 Oct 2003 21:41:16 +0100
Message-ID: <21ltpvk6krs24nr2s9mmacqd8nppnmgtdf@4ax.com>

On Tue, 28 Oct 2003 14:09:49 -0600, mommy dba <mommydba_at_netscape.com> wrote:

>Chaining, technically occurs during an
>update when the record can no longer fit into it's original location.
>Then it will put the remainder in another place.

You should discriminate between row chaining and row migration. You are describing migration.
If a record doesn't fit in one block, because the record is too big, it will definitely be chained.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Oct 28 2003 - 14:41:16 CST