Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!west.cox.net!cox.net!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: Why my Temporary tablespace is always 99% full ? Date: Mon, 05 May 2003 19:15:31 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: <407dbvk2i77tsl7r964bquo7g77e9np0oo@4ax.com> Reply-To: postbus@sybrandb.demon.nl References: X-Newsreader: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 20 Xref: core-easynews comp.databases.oracle.server:185326 X-Received-Date: Mon, 05 May 2003 10:14:42 MST (news.easynews.com) On Mon, 5 May 2003 21:57:32 +0800, "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 ? > > > 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