Why my Temporary tablespace is always 99% full ?
From: cpchan <cpchaney_at_netvigator.com>
Date: Mon, 5 May 2003 21:57:59 +0800
Message-ID: <b95qgu$b8o4_at_imsp212.netvigator.com>
[Quoted] 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 Mon May 05 2003 - 15:57:59 CEST
Date: Mon, 5 May 2003 21:57:59 +0800
Message-ID: <b95qgu$b8o4_at_imsp212.netvigator.com>
[Quoted] 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 Mon May 05 2003 - 15:57:59 CEST