Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Locally Managed Tablespace Survey

RE: Locally Managed Tablespace Survey

From: Gait, Christopher <>
Date: Tue, 20 Jun 2000 09:29:52 -0400
Message-Id: <>

I'll continue looking for some more details on this. I've confirmed that the 'waking up SMON' trick works, since I've tried it, but I haven't engaged in the same long-term observation you are doing...yet.

Chris Gait

-----Original Message-----
From: Gaja Krishna Vaidyanatha [] Sent: Monday, June 19, 2000 7:26 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Locally Managed Tablespace Survey


Thanks for the link and I did check it out. It talks about how to "force" SMON to clean up a temp segment left over by an aborted transaction, by faking a change to the TEMP tablespace's default storage clause. It also talks about how SMON will drop the temp segment on wake up after 2 hours.

My point is that, the temp segment really does not get dropped after 2 hours even after SMON wakes up, at least I have not seen it do that. I have gone days waiting for this to occur, but in vain.

In everything that I have seen and tested, the temp segment gets dropped only on instance shutdown. Again, my tested versions were 8.0.5.X on various platforms. If you do find evidence that does suggest that the temp segment does gets dropped, please be kind enough to drop a line, as I would like to learn the "circumstances" under which that occurred. I will be one heck surprised if that in fact occurs, as it will go directly against some of the "fundamental rationale" for "true temporary" tablespaces. Thank you for taking the time to research this and sharing the knowledge.

Best Regards,


Gaja Krishna Vaidyanatha | Brio Technology | (972)-304-1170

"Opinions and views expressed are my own and not of Brio Technology"

Do You Yahoo!?
Send instant messages with Yahoo! Messenger.
Author: Gaja Krishna Vaidyanatha

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
Received on Tue Jun 20 2000 - 08:29:52 CDT

Original text of this message