Re: Chained Rows VS new extent allocation

To answer your original question, Oracle prefers to have everything in one place, so the answer is: Oracle will allocate a new block to fit the entire record. It will allocate additional space if it cannot find room to put it into a spot. Chaining, technically occurs during an update when the record can no longer fit into it's original location. Then it will put the remainder in another place.

Mike wrote:

> 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 - 14:09:49 CST