On insert Oracle will put the row in a block where it fits. So if there is
not enough room in a block then it will put it in a new block. If the row
is larger than a block then it will chain it because there isn't any choice.
Chaining occurs when rows are updated and become too large to fit into a
block.
Jim
"Mike" <mbrugo_at_despammed.com> wrote in message
news:ch0tpvk2m69eits4m2koib0eokdmo4f8o9_at_4ax.com...
> Hi people,
> does oracle prefer (during an insert) break the record in n parts to
> fit in free space of allocated blocks or allocate a new block to fit
> the entire record ?
>
> Mike
>
Received on Tue Oct 28 2003 - 08:59:47 CST
