Re: Why my Temporary tablespace is always 99% full ?

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Mon, 05 May 2003 15:47:53 GMT
Message-ID: <3EB68660.422A46D7@telusplanet.net>

cpchan wrote:

> I don't understand why my Temporary tablespace is always 99% full even we
> shut down the database for a UNIX tar backup on every 6:00 am.
> Do I need to turn off the whole UNIX machine and then turn its power again
> so that all the content of the Temporary tablespace will be cleared ?
> If no, how can I clear all the content of a Temporary tablespace on an
> Oracle 8i RDBMS ?

Is this a problem? Are you getting errors about your temp tablespaces? Why the urgency to clear them?

AFAIK, these are reused by the system automatically. The system will do the clearing as needed. Received on Mon May 05 2003 - 10:47:53 CDT