Re: Should a temporary segment disappear after 125 minutes?

From: broom <broom_at_voicenet.com>
Date: 6 Jun 2001 19:45:23 -0700
Message-ID: <c948eb61.0106061845.5eb380ff@posting.google.com>

yong321_at_yahoo.com (Yong Huang) wrote in message news:<b3cb12d6.0106061246.4d107c27_at_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. Received on Wed Jun 06 2001 - 21:45:23 CDT