Re: Temp Tablespace very large oracle 9ir2

>>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. Received on Wed Nov 30 2005 - 01:22:54 CST