Re: archive question --- too many archive logs generated during data load

Sybrand Bakker <postbus_at_sybrandd.remove-this.demon.nl> wrote:

>Redo log consists of
>a log of the changed bytes in a block both for tables and indexes.
>As far as I know there are no free holes in a datablock, the free space is
>always contiguous. So your insert might force Oracle to rearrange the block.

AIUI, there can be holes in clean blocks, for example after a row migration has happened. Oracle will re-organise the block on-the-fly when it tries to write data that the Total Space field says should fit, but there isn't room at the current Free Space offset.

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/