Re: Is space released after deletes?

"Brian P. Mac Lean" <brian.maclean_at_teldta.com> wrote:
>
>Yuri Ludevig wrote:
>>
>> I can't get a definite answer if Oracle reuses space after deletes. I
 ran
>> analyze before and after deletes (I deleted all rows form the table)
 and
>> statistics didn't seem to change (number of empty blocks, extents,
 bytes
>> used, etc). Anybody out there knows for sure if you have to do
>> export/import or Oracle takes care of all the holes?
>> Thanks,
>> Yuri in NY
>
>
>For a table, Oracle will only reuse the deleted row space once the
 blocks
>freespace/percent used has fallen below the "pctused" value. Once it
 does
>the blocks address is inserted into the beginning of the freelist chain
>for the table so that it will be reused before a new/never used block is.
 

>
>For indexes, Oracle will only reuse deleted space if all the index
 values
>stored in a leaf block are deleted. I don't know about branch blocks
 being
>reused but I quess it would live by the same rule.
>
Brian, do you know if that would be true for Oracle running on Unix/AIX platform?
I remember from the Oracle class that the intructor was saying specifically that in theory the space should be reused but in reality it is not on AIX.
Thanks,

   Yuri Received on Wed Sep 11 1996 - 00:00:00 CEST