RE: temporary tablespace not emptied , how to?

From: SARKAR, Samir <Samir.SARKAR_at_nottingham.sema.slb.com>
Date: Thu, 25 Oct 2001 07:24:38 -0700
Message-ID: <F001.003B43F0.20011025071544@fatcity.com>

Maya,
 

Check whether ur TEMP
tablespace is of the type Temporary by issuing the following query :
 
 select

tablespace_name, status, contents from dba_tablespaces where

tablespace_name = 'TEMP'
;
 
 If the TEMP

tablespace is of type Permanent, the cleanup is performed by SMON after the process
using it has been
completed. If it is of type Temporary, it should get emptied when the instance is
shut down and
restarted.
 

You can check from
v$sort_segment to see how many of the sort segments r currently using the
Temporary
tablespace.
 

Hope this
helps.
 

Samir Sarkar
Oracle DBA - Lennon
Team Schlumberger<FONT
face=Impact color=#800000>Sema
Email :
samir.sarkar_at_sema.co.uk <FONT face=Verdana color=#000080 size=1>         
samir.sarkar_at_nottingham.sema.slb.com <FONT face=Verdana color=#000080 size=1>Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418
Ext. 76217 Fax
: +44 (0) 115 - 957
6018           

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Maya Kenner   [mailto:maya.kenner_at_trema.com]Sent: 25 October 2001   14:20To: Multiple recipients of list ORACLE-LSubject:   temporary tablespace not emptied , how to?   <SPAN
  class=354450612-25102001>Hello,
  <SPAN
  class=354450612-25102001> 
  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 ? <SPAN class=354450612-25102001>  Thanks, Maya

  ---

This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema.
If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.

---

Received on Thu Oct 25 2001 - 09:24:38 CDT