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

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 6 May 2003 10:12:06 +0100
Message-ID: <b97u7v$ccs$1$8300dec7@news.demon.co.uk>

See the FAQ below, item:

My temporary tablespace never clears down, what should I do ?

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

____Denmark__May 21-23rd
____Sweden___June
____Finland__September
____Norway___September

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK_(Manchester)_May x 2
____Estonia___June (provisional)
____Australia_June (provisional)
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"cpchan" <cpchaney_at_netvigator.com> wrote in message
news:b95qg4$b8m15_at_imsp212.netvigator.com...


> 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 ?

>

>

>

>

Received on Tue May 06 2003 - 04:12:06 CDT