Re: Freeing up temporary segments

If you are at 7.3 or greater, make sure you've got your TEMP tablespace marked as TEMPORARY. As far as deallocating the extents in a TEMP segment, why would you want to? Allocating/deallocating extents is about the most expensive operation in an Oracle database. If you mark the TEMP tablespace as TEMPORARY, then it will simply leave all the extents allocated. Unless you are truly hurting for the space, leave the TEMP segments allocated, as this will yield better performance on sorts, index-builds, etc.

Good luck,
Dave

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 Thu Apr 02 1998 - 00:00:00 CST