From: broom@voicenet.com (broom)
Newsgroups: comp.databases.oracle.server
Subject: Re: Should a temporary segment disappear after 125 minutes?
Date: 6 Jun 2001 19:45:23 -0700
Organization: http://groups.google.com/
Lines: 10
Message-ID: <c948eb61.0106061845.5eb380ff@posting.google.com>
References: <b3cb12d6.0106061246.4d107c27@posting.google.com>
NNTP-Posting-Host: 24.12.113.73
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 991881923 29860 127.0.0.1 (7 Jun 2001 02:45:23 GMT)
X-Complaints-To: groups-support@google.com
NNTP-Posting-Date: 7 Jun 2001 02:45:23 GMT


yong321@yahoo.com (Yong Huang) wrote in message news:<b3cb12d6.0106061246.4d107c27@posting.google.com>...
> Oracle 8.0.5 Enterprise Ed on Sparc Solaris 2.6
> 
> I know it'll go away if I bounce the database. I also know leaving it
> in TEMP is OK. What I'm doing is only for studying how Oracle works.

Don't be too sure.  In 8.1.6 and 8.1.7 I've experienced a bug that
occasionaly will fill TEMP with undroppable segments, even on 
instance bounce.  I've dropped and recreated various temp tablespaces
to get rid of them.