Re: chained rows

From: Kevin Brand <kevin.brandx_at_tel.gte.com>
Date: Thu, 4 Mar 1999 13:38:35 -0600
Message-ID: <7bmnlc$sau$1@news.gte.com>

What is your char size? Remember only varchar will be "cut" to length in the block.

-Kevin

remove the x for an email reply
chuckh_at_safeplace.net wrote in message <7bmh13$o7g$1_at_nnrp1.dejanews.com>...
>I have a table who's avg_row_len is 1718 bytes and who's percent free is
10%.
>According to Oracle's formula, with a 2k block size, I should have 1762
bytes
>available in each block. But every row in the table is chained! This is not
an
>issue where rows grew to that size. Every column is a CHAR and NOT NULL so
the
>row size is constant from the time the row is inserted, until the time it's
>deleted.
>
>Why am I getting chained rows?
>
>The database version is 8.0.4
>--
>Chuck Hamilton
>chuckh_at_safeplace.net
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Mar 04 1999 - 13:38:35 CST