Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: mngong@yahoo.com (michael ngong) Newsgroups: comp.databases.oracle.server Subject: Re: Why my Temporary tablespace is always 99% full ? Date: 5 May 2003 10:03:36 -0700 Organization: http://groups.google.com/ Lines: 15 Message-ID: References: NNTP-Posting-Host: 12.161.114.203 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1052154216 12635 127.0.0.1 (5 May 2003 17:03:36 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 5 May 2003 17:03:36 GMT Xref: core-easynews comp.databases.oracle.server:185323 X-Received-Date: Mon, 05 May 2003 10:03:04 MST (news.easynews.com) "cpchan" wrote in message news:... > 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 it of type permanant or temporary? How big is it? Did changing pctincrease from to some other value and back(0 and 1 most often) have any effect? Michael T Ngong