It was my understanding that this will remain 100% full until you
shutdown. Oracle no longer deallocates the temp segments, it just allows
other users to use them , thus reducing the overhead of allocating and
deallocating the segments.

I could be wrong, if someone else knows, please speak up.

----- Forwarded by Chris Guillaume/cguilla/DFSI on 11/12/2004 09:14 AM
-----

You need to check what active sql queries are running. If you are saying
it is "always 100%" then it means either it is not properly sized or the
queries are not efficient and hence they do not choose the efficient
plan.

HTH

GovindanK

On Thu, 23 Feb 2006 18:47:11 +0530, "Hari Ganapathi "
<oracledba-ezmlmshield-x76991013.[Email address protected] said:
>
> Hi All,
>
> I have a 9i database on windows 2000,my temporary tablespace is always
> 100%
> full because of which users query is taking a long time.How can i flush
> this tablespace.It is locally managed.
>
> Thanks in advance.
>
> Regards,
> Hari

Oracle LazyDBA home page