Re: Temp Tablespace very large oracle 9ir2

Might as well check whether some bad queries are causing to temp-space to run away,
The v$sort_usage might be helpful in this case

Rgds
Sng

aj70000_at_hotmail.com wrote:
> so if the query is running it may not be processed in an OLTP kind of
> env. if the maxsize is reached. What is a better approach for temp
> tablespace?
>
> Allow it to autoextend and the drop and recreate the tablespace if it
> goes beyond a threshold (let us say 50 GB)
> or
> Classify maxsize on the datafile and wait for the complain.
>
> Thanks again
> AJ
Received on Wed Nov 30 2005 - 00:00:08 CST