RE: temporary segment

If you have your temporary tablespace set as type temp (which you should) then old segments don't get cleaned up, they stay there to be reused by later sorts (thereby saving the time it would have taken to create a new extent).

-----Original Message-----
From: Uppal, Inde [mailto:Inde.Uppal_at_chelwest.org] Sent: Thursday, April 27, 2000 6:30 AM
To: Multiple recipients of list ORACLE-L Subject: temporary segment

Hi
Running Oracle 8.0.5 on NT. There was an export running as system, which hung (should have taken 40 mins and was still going 12 hours later!). I killed the session, but it is still being shown in top sessions (as killed), and there is a temporary segment in the temp tablespace which hasn't been cleaned up. It has been sitting there for the last 48hours.

Inde Uppal
Oracle DBA
System Support

This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice of its status. Please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any other person: to do so could be a breach of confidence. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of the Trust.

 Thank you for your co-operation. Received on Thu Apr 27 2000 - 14:24:56 CDT