Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TEMP tablespace grows all the time!
zeevikm_at_hotmail.com (SGA) wrote in message news:<b0fb5246.0203310632.3ed23a3a_at_posting.google.com>...
> Hello All.
>
> RDBMS: 8.1.7.3
> O/S : Sun Solaris 8
>
>
> Localy Managed Temporary tablespace (with unlimited autoextend enabled
> on datafiles) is 40G already - and keeps growing.
> Tablespace is locally managed, and the DB is 24x7 environment,
> so shutdown is not an option to reduce the tablespace size.
>
> I know such a problem exists since early 8i versions (at least 8.1.6 and up),
> but nobody seems to know the answer ...
>
> Please Advice.
> Regards.
How about making offline and back online?
Received on Sun Mar 31 2002 - 19:21:11 CST