Re: Temp Tablespace

jackwithman_at_my-deja.com wrote:
>
> Hello Everyone,
>
> I am very curious of something.
> I'm running under oracle 8.1.5 and my temp tablespace (200 M) is always
> full (99%). As soon as I shut down my database, the temp tablespace is
> purged but when I bring the database back up it starts growing and in
> half a day, temp is choking and I have sometimes failures to extend.
>
> Looks like a lot of space is lost.
> Is there any way to 'shrink' it, other than bringing the tablespace
> offline and online right after?
>
> ThanXs for your help.

A couple things to check:

1. Make sure that TEMP tablespace will only allow the creating of temporary segments. By default it does not have that restriction.
2. Make sure that there are no rollback segments defined in the TEMP tablespace.
3. Make sure that applications are not using large joins and then leaving the session open.