Re: Temp Tablespace very large oracle 9ir2

From: <aj70000_at_hotmail.com>
Date: 30 Nov 2005 16:48:39 -0800
Message-ID: <1133398119.621396.251850@z14g2000cwz.googlegroups.com>

Carlos wrote:
> >>Unfortunately, when auto-extend is permitted, it appears
> >>the temporary tablespace will prefer to getting a new &
> >>empty extent rather than take the overhead of monitoring
> >>and cleaning the existing but unused extents.
> >>This seems to cause unlimited growth - and that seems
> >>to be managed simply by putting a fixed size (or max size) on the tablespace.
>
> Notice: This happpens to UNDO too.
>
> Cheers.
>
> Carlos.

If I query v$sort_usage there is nothing in there. Is there any other way to find out the run of query?

Thanks
AJ Received on Wed Nov 30 2005 - 18:48:39 CST