Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Should a temporary segment disappear after 125 minutes?
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