RE: temporary tablespace not emptied , how to?

[SARKAR, Samir]

Right Amar.....sorry, I missed that point.

 

Cheers !!

 

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTED]
          [EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018           

-----Original Message-----
From: Amar Kumar Padhi [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 17:00
To: Multiple recipients of list ORACLE-L
Subject: 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
amar

 

-----Original Message-----
From: SARKAR, Samir [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 7:16 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: temporary tablespace not emptied , how to?

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
SchlumbergerSema
Email : [EMAIL PROTECTED]
          [EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018           

-----Original Message-----
From: Maya Kenner [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 14:20
To: Multiple recipients of list ORACLE-L
Subject: temporary tablespace not emptied , how to?

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



___________________________________________________________________________
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.
___________________________________________________________________________