Re: Freeing up temporary segments

From: Alan V <alanv_at_opustel.com>
Date: 1998/04/01
Message-ID: <6ftt9n$7jp@news9.noc.netcom.net>#1/1

ALTER TABLESPACE xxxxx COALESCE;
This will coalesce the temp segments, as long as you are not talking about the TEMPORARY tablespace, because you do not want to coalesce that.

Alan V.

Tony de Lange wrote in message <6ft14u$dnj$1_at_news01.iafrica.com>...
>When a sort completes or a table/index is dropped, the originally allocated
>extents is not freed up immediately. Apparently SMON wakes up at certain
>intervals to free up these temporary segments.
>
>Does anybody know how I can increase the frequency to get rid of "unused"
>space ?
>
>
Received on Wed Apr 01 1998 - 00:00:00 CST