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

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Mon, 05 May 2003 19:15:31 +0200
Message-ID: <407dbvk2i77tsl7r964bquo7g77e9np0oo@4ax.com>

On Mon, 5 May 2003 21:57:32 +0800, "cpchan" <cpchaney_at_netvigator.com> 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 ?
>
>
>

Temporary segments in a temporary tablespace are allocated in the same fashion as rollback segments. Your issue is hence a non-issue

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon May 05 2003 - 12:15:31 CDT