Re: chained rows

Isn't it your PCTFREE that's reserving 10% (roughly 170 bytes) of each block - or did I misunderstand the original post?

JR

"Kevin Brand" <kevin.brandx_at_tel.gte.com> wrote:

>
>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 Fri Mar 05 1999 - 05:35:29 CST