Re: Temp Tablespace very large oracle 9ir2

On Tue, 29 Nov 2005 14:21:47 -0800, aj70000 wrote:

> Frank,
>
> What happens if more space is needed on the temp tablespace? It does
> not reclaim the space automatically.
> Thanks for your insight.
>

Set it to a maximum size. If, and only if, you get a complaint, should you increase the size.

When checking the database information it will appear to be in use - correct in a sense, as it is 'allocated', but it is often empty and waiting to be recycled.

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.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***