You don't want the tablespace to be emptied - thats the whole idea of temp segs. By leaving them 'hanging around' its much faster for session to re-use the segments (they don't need to be re-allocated/created etc).
You can monitor sorting with the v$sort.. views. hth connor --- Maya Kenner <[EMAIL PROTECTED]> wrote: > Hello, > > My "TEMP" temporary tablespace does not get emptied > , I thought rebooting > would drop all the temporary objects stored in it > but it does not, any idea > why and how to empty it ? > Alternative question: > - is there a way to know which objects are in the > TEMP tablespace > - does oracle do redo logs when working in temporary > segments ? > > Thanks, Maya > ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" ____________________________________________________________ Nokia Game is on again. Go to http://uk.yahoo.com/nokiagame/ and join the new all media adventure before November 3rd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).