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
>

Oracle LazyDBA home page