Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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:
![]() |
![]() |