RE: temporary tablespace not emptied , how to?

From: SARKAR, Samir <Samir.SARKAR_at_nottingham.sema.slb.com>
Date: Thu, 25 Oct 2001 08:34:10 -0700
Message-ID: <F001.003B476F.20011025084023@fatcity.com>

Right Amar.....sorry, I
missed that point.
 
Cheers
!!
 
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: Amar Kumar Padhi   [mailto:TS2017_at_emirates.com]Sent: 25 October 2001   17:00To: Multiple recipients of list ORACLE-LSubject:   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?
<FONT

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

Received on Thu Oct 25 2001 - 10:34:10 CDT