Problem: database table/index sizing for Sum Length Columns greater than Available Data Space

Sorry, but this is just the way Oracle works.

If your records are by design bigger than the available dataspace, you will

get chaining. If this is a structural problem in your database the only way

to resolve it is to increase the block size. There might be formulas, but

you definitely don't want the chaining, as you will be getting more than one

1 I/O to retrieve a record.

Hth,

Sybrand Bakker, Oracle DBA

Quote:

> Hi there,

> I am trying to size Oracle 8.x tables and am having difficulty due to

> the fact that the formulas Oracle gives are only appropriate if your Space

> Used Per Row (i.e. Sum Length Columns + Overhead) is less than your

> Available Data Space (i.e. Block_Size - Header Space - Pct_Free_Space).

> What if Space Used Per Row >= Available Data Space? That is, what if

> you have big columns which are much bigger than your block size and you

> don't want to increase the block size?

> If you could point me to where there are formulas for this particular