Re: chained rows

Yes, it's reserving 170 bytes, but 2048 (the block size) minus 170 minus the other block header stuff comes out to 1762 bytes. If all the columns are CHAR and NOT NULL, the row length must be fixed at the avg_row_len of 1718. So if avg_row_len (1718) is less than available space per block (1762), why are all the rows chaining?

        Chuck Hamilton

In article <36dfc129.1601435_at_news.earthlink.net>,   wrote:
> 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
> >
> >
>
>

--
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:10:11 CST