From: yong321@yahoo.com (Yong Huang) Newsgroups: comp.databases.oracle.server Subject: Should a temporary segment disappear after 125 minutes? Date: 6 Jun 2001 13:46:54 -0700 Organization: http://groups.google.com/ Lines: 17 Message-ID: NNTP-Posting-Host: 192.94.8.250 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 991860415 25920 127.0.0.1 (6 Jun 2001 20:46:55 GMT) X-Complaints-To: groups-support@google.com NNTP-Posting-Date: 6 Jun 2001 20:46:55 GMT 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@yahoo.com