Re: Freeing of chained row blocks

A copy of this was sent to vijaylamba_at_my-deja.com (if that email address didn't require changing) On Sat, 04 Dec 1999 10:52:09 GMT, you wrote:

the blocks *are* freed automatically (pctused will constrol when this happens) and put on the free list for that table. subsequent inserts/updates to that table can and will reuse these blocks. they are not freed for use by some other table but they can be reused by that table that allocated them in the first place.

>Hi,
>The blocks are not freed automatically. You will need to take an export
>of that object and import it back. That will also defrag your extents.
>Hope this helps.
>Bye
>Vijay
>
>In article <38481419.9136FA12_at_arlut.utexas.edu>,
> Chip Gentry <cgentry_at_arlut.utexas.edu> wrote:
>> Are blocks associated with a chained row automatically freed and
>> available for reuse if the row decreases in size such that chaining is
>> no longer required?
>>
>> Is there a difference between version 7.0.16 and version 7.3.3 in how
>> this is handled?
>>
>> Thanks,
>> --
>> ------------------------------------------------------------
>> M. L. "Chip" Gentry
>> ---------------------------------------------------------------
>>
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Dec 04 1999 - 08:13:42 CST