Re: TEMP tablespace grows all the time!

Thanks Adrian,
All extents are uniform of course (SORT_AREA_SIZE + DB_BLOCK_SIZE), so probably that is not the issue.

Thanks again for your response.

"Adrian Carlson-Hedges" <adrian.ch_at_btinternet.com> wrote in message news:<a87mrh$oma$1_at_helle.btinternet.com>...
> If I had to guess at the cause of the problem, it would be that you do not
> have uniform extent sizes, and hence you are fragmenting this tablespace
> into many small chunks. Each time it needs to grab a decent sized chunk it
> has to grow the tablespace. If this is the problem, then using a uniform
> extent size should cure this.
>
> As to how to go about reducing it. That would probably depend on your
> circumstances. If you have only a few users, you could simply create a new
> Temporary tablespace, and assign this as their TEMP tablespace. I'm not sure
> when the assignment will happen. It probably won't affect connected session,
> and hence man not be until they next login. But at least in a few hours/days
> you should be able to drop (and if necessary) recreate your TEMP tablespace.
>
Received on Mon Apr 01 2002 - 02:37:53 CST