Re: Freeing up temporary segments

BINGO ! Finally, someone who understands TEMPORARY tablespace other than myself.
Way to go, David.

Alan V
"I can please only one person per day.
Today is not your day.
Tomorrow isn't looking good either."

David Sisk wrote in message ...
>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