Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> 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: