Re: Should a temporary segment disappear after 125 minutes?

On 6 Jun 2001 13:46:54 -0700, yong321_at_yahoo.com (Yong Huang) wrote:

>Oracle 8.0.5 Enterprise Ed on Sparc Solaris 2.6
>
>In a small test database that just started up, I created an index and
>left one temporary segment 3.132 in TEMP (which is a
>dictionary-controlled temporary tablespace with pctincrease 0). I
>didn't set any event in init.ora or at session level. I thought that
>after 125 minutes SMON should come in and drop this segment, according
>to Jonathan Lewis' paper. But it's still here after 3 hours. I just
>tried oradebug wakeup 6 in svrmgrl, where 6 is the SID of SMON. It
>didn't get rid of this segment either. Maybe I'm missing something
>obvious. Thanks for an explanation.
>
>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.
>
>Yong Huang
>yong321_at_yahoo.com
Received on Thu Jun 07 2001 - 08:18:06 CDT