Re: Freeing up temporary segments

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1998/04/01
Message-ID: <6fta6i$s3l$1@hermes.is.co.za>#1/1

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 ?

Kicking SMON telling it to wakeup via the oradebug command in server manager? But I'm not so sure if it will work, or whether or not it is such a good idea either... :-)

regards,
Billy Received on Wed Apr 01 1998 - 00:00:00 CST