however, you can take it offline and then take it back online.
raza


-----Original Message-----
From: GovindanK
[mailto:oracledba-ezmlmshield-x62923225.[Email address protected]
Sent: Friday, November 12, 2004 8:07 PM
To: LazyDBA Discussion
Subject: Re: Temporary tablespace cleanup


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
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html





Oracle LazyDBA home page