RE: temporary tablespace not emptied , how to?

good
one.
Moreover,
if contents is 'Permanent', check if any objects have actually been created in the tablespace. You could select from dba_segments where tablespace_name = 'TEMP'. Check for segments other than rollback and temporary.
 
rgds <FONT face=Courier
color=#000000 size=2>amar
 

<FONT face="Times New Roman"

  size=2>-----Original Message-----From: SARKAR, Samir   [mailto:Samir.SARKAR_at_nottingham.sema.slb.com]Sent: Thursday,   October 25, 2001 7:16 PMTo: Multiple recipients of list   ORACLE-LSubject: RE: temporary tablespace not emptied , how   to?
  Maya,
<FONT

face=Arial> 
  Check whether ur TEMP
  tablespace is of the type Temporary by issuing the following query   :
<FONT

face=Arial> 
   select
  tablespace_name, status, contents from dba_tablespaces where   

  tablespace_name = 'TEMP'
  ;
<FONT

face=Arial> 
   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.
<FONT

face=Arial> 
  You can check from
  v$sort_segment to see how many of the sort segments r currently using   the
  Temporary
  tablespace.
<FONT

face=Arial> 
  Hope this
  helps.
   
  Samir Sarkar
  Oracle DBA - Lennon
  Team <FONT face=Impact
  color=#000080>SchlumbergerS<FONT
  face=Impact color=#000080>ema <FONT face=Verdana   color=#000080 size=1>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 <FONT face=Verdana   color=#000080 size=1>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<FONT size=3>___________________________________________________________________________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 thisemail 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.___________________________________________________________________________