Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Should a temporary segment disappear after 125 minutes?

Should a temporary segment disappear after 125 minutes?

From: Yong Huang <yong321_at_yahoo.com>
Date: 6 Jun 2001 13:46:54 -0700
Message-ID: <b3cb12d6.0106061246.4d107c27@posting.google.com>

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 Wed Jun 06 2001 - 15:46:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US