Re: chained rows

char size varies on every field. But remeber, they're all char and all not null. That should mean all rows are the same length, 1718 bytes according to dba_tables. 2k - block overhead is > 1718 so why are the rows chaining?

        Chuck Hamilton

In article <7bmnlc$sau$1_at_news.gte.com>,   "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.

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

--
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 - 10:04:53 CST