chained rows

From: <chuckh_at_safeplace.net>
Date: Thu, 04 Mar 1999 17:48:22 GMT
Message-ID: <7bmh13$o7g$1@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 - 11:48:22 CST