Re: Free space management in Blocks

From: tina london <tinalondon_at_demon.co.uk>
Date: Wed, 1 Jun 2005 14:02:29 +0100
Message-ID: <d7kbl4$gqs$1$8300dec7@news.demon.co.uk>

<agarwalp_at_eeism.com> wrote in message
news:1117625652.469632.285630_at_g49g2000cwa.googlegroups.com...
> I read in the Oracle 9i Concepts document, that a free space generated
> by deleting or updating of data can be used only by an insert statement
> in the same transaction as of delete/update or any insert statement
> immediately after the DML statement. So does that mean if there is no
> immediate insert statement that free space will never be used ? Please
> clarify my doubt.
>

It may be used the next time you perform an insert, depending on the state of the free block list. Notice the word may. Received on Wed Jun 01 2005 - 08:02:29 CDT