Re: Did Oracle Re-use deleted record space ?

Oracle will reuse the deleted space. It will not do this very quickly if you are using all defaults.

Oracle manages space at the block level. Each segment (index, table, rollback, etc) has values for pct_free and pct_used. Oracle also has what is called a free list (normally one per segment) which it used to track which blocks it can insert data into.

Oracle will continue inserting rows into a block until it has only a relatively small amount of free space left (determined by pct_free). At this point it is removed from the freelist. It will return to the free list when enough data has been deleted from the block bring the amount of data used below a value determined by pct_used.

The default values for pct_free and pct_used at 10% and 40% respectively (on most platforms, if not all).

If you want Oracle to reuse the space more quickly, increase the pct_used value.

Choong Chee Tuan wrote:
>
> If no, then how do I compact the deleted record ?
Received on Mon Nov 02 1998 - 19:40:02 CET