Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Problem in Temporary tablespace.
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C04367.9EA5979E
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Nguyen, babu,=20
You don't need to clean it up. If the tablespace is defined as =
temporary,
temp segments are not deallocated after use. This saves time when the =
next
process needs to use temp space, as the extents are already allocated.=20
Do not worry about this "problem". This is working as intended.
If you don't like to see this, change your temporary tablespace to be permanent. =20
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
V: 954.484.3191, x174 F: 954.484.2933=20 C: 954.658.5849
"The information contained herein does not express the opinion or =
position
of Qode.com and cannot be attributed to or made binding upon Qode.com."
-----Original Message-----
From: Babu.Nagarajan_at_Cummins.com [mailto:Babu.Nagarajan_at_Cummins.com]
Sent: Tuesday, October 31, 2000 11:21 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Problem in Temporary tablespace.
hi
in some cases u need to force smon to do the cleanup. this can be done =
aby
altering one of the temp tablespace parameters. actually the value of =
the
parameters do not matter. so u can issue command with the new parameter
same as the existing one...
babu
Truc Nguyen <truc_at_nguyen.as>@fatcity.com on 10/31/2000 05:00:58 AM
Please respond to ORACLE-L_at_fatcity.com
Sent by: root_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
=A0=A0=A0 =A0=A0=A0 Hi listers,
=A0=A0=A0 We have some average databases in version 8.0.4.2.1.
The temporary tablespace is very big (untill 10 gig) but it's very =
often
full.
Does any one know why and how can i get rid of this problem ?
=A0=A0=A0 Thanks a lot.
=A0=A0=A0 Nguyen
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20
Author:=20
INET: Babu.Nagarajan_at_Cummins.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
------_=_NextPart_001_01C04367.9EA5979E
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =charset=3Diso-8859-1">
<TITLE>RE: Problem in Temporary tablespace.</TITLE> </HEAD> <BODY>
<P><FONT SIZE=3D2>Nguyen, babu, </FONT>
</P>
<P><FONT SIZE=3D2>You don't need to clean it up. If the = tablespace is defined as temporary, temp segments are not deallocated = after use. This saves time when the next process needs to use = temp space, as the extents are already allocated. </FONT></P>
<P><FONT SIZE=3D2>Do not worry about this "problem". =
This is working as intended.</FONT>
</P>
<P><FONT SIZE=3D2>If you don't like to see this, change your temporary = tablespace to be permanent. </FONT> </P>
<P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT> <BR><FONT SIZE=3D2>Oracle Database Administrator</FONT> <BR><FONT SIZE=3D2>Qode.com</FONT> <BR><FONT SIZE=3D2>4850 North State Road 7</FONT> <BR><FONT SIZE=3D2>Suite G104</FONT> <BR><FONT SIZE=3D2>Fort Lauderdale, FL 33319</FONT> </P> <P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT> <BR><FONT SIZE=3D2>F: 954.484.2933 </FONT><BR><FONT SIZE=3D2>C: 954.658.5849</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A></FONT> </P>
<P><FONT SIZE=3D2>"The information contained herein does not = express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."</FONT></P> <BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Babu.Nagarajan_at_Cummins.com [<A = HREF=3D"mailto:Babu.Nagarajan_at_Cummins.com">mailto:Babu.Nagarajan_at_Cummins=
.com</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Tuesday, October 31, 2000 11:21 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: Problem in Temporary tablespace.</FONT> </P>
<P><FONT SIZE=3D2>hi</FONT>
</P>
<P><FONT SIZE=3D2>in some cases u need to force smon to do the cleanup. =
this can be done aby</FONT>
<BR><FONT SIZE=3D2>altering one of the temp tablespace parameters. =
actually the value of the</FONT>
<BR><FONT SIZE=3D2>parameters do not matter. so u can issue command =
with the new parameter</FONT>
<BR><FONT SIZE=3D2>same as the existing one...</FONT>
</P>
<P><FONT SIZE=3D2>babu</FONT> </P> <BR> <BR> <BR>
<P><FONT SIZE=3D2>Truc Nguyen <truc_at_nguyen.as>@fatcity.com on =
10/31/2000 05:00:58 AM</FONT>
</P>
<P><FONT SIZE=3D2>Please respond to ORACLE-L_at_fatcity.com</FONT> </P>
<P><FONT SIZE=3D2>Sent by: root_at_fatcity.com</FONT> </P> <BR>
<P><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L = <ORACLE-L_at_fatcity.com></FONT>
<BR><FONT SIZE=3D2>cc:</FONT> </P> <BR> <BR> <BR>
<P><FONT SIZE=3D2>=A0=A0=A0 =A0=A0=A0 Hi listers,</FONT> </P>
<P><FONT SIZE=3D2>=A0=A0=A0 We have some average databases in =
version 8.0.4.2.1.</FONT>
<BR><FONT SIZE=3D2>The temporary tablespace is very big (untill 10 gig) =
but it's very often</FONT>
<BR><FONT SIZE=3D2>full.</FONT>
<BR><FONT SIZE=3D2>Does any one know why and how can i get rid of this =
problem ?</FONT>
</P>
<P><FONT SIZE=3D2>=A0=A0=A0 Thanks a lot.</FONT> </P>
<P><FONT SIZE=3D2>=A0=A0=A0 Nguyen</FONT> </P> <BR> <BR>
<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: </FONT> <BR><FONT SIZE=3D2> INET: Babu.Nagarajan_at_Cummins.com</FONT> </P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=-----</FONT>
![]() |
![]() |