RE: Locally Managed Tablespace Survey

From: Gait, Christopher <cgait_at_condor.nrl.navy.mil>
Date: Tue, 20 Jun 2000 09:29:52 -0400
Message-Id: <10534.109835@fatcity.com>

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.

Regards,
Chris Gait

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

Chris,

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.

• "Gait, Christopher" <cgait_at_condor.nrl.navy.mil> wrote:
  > I've been trying to track down the source I got this from, but
  > not
  > succeeded. There is a good hint on cleaning up the temp
  > segments here:
  >
  > http://www.oracle.com/oramag/code/tips2000/Tip18.html
  >
  > The article mentions 'more than two hours'in connection with
  > SMON waking up
  > to clean out the temp segments, but not the specific '25
  > cycles' I have
  > heard of. The figure of 125 minutes is 25 standard 5 minute
  > cycles for SMON,
  > and is supposedly the time between normal wakeups for temp
  > cleanup.
  >
  > Regards,
  > Christopher Gait
  > Oracle DBA
  >
  > (Semi)permanent address: cjgait_at_yahoo.com
  > http://www.geocities.com/athens/3623
  >
  > "Death is nature's way of saying: NEXT!"
  >
  >
  > > -----Original Message-----
  > > From: Gaja Krishna Vaidyanatha [mailto:gajav_at_yahoo.com]
  > > Sent: Monday, June 19, 2000 1:17 PM
  > > To: Multiple recipients of list ORACLE-L
  > > Subject: RE: Locally Managed Tablespace Survey
  > >
  > >
  > > Chris,
  > >
  > > Yes, I agree that it is worthwhile to locally manage temp
  > > spaces, no question about it. I am just not sure about the
  > 125
  > > minute clean up interval (whether it even occurs). In my
  > > experience, last tested in 8.0.5.X on Solaris, HP-UX, SGI
  > Irix,
  > > and NT, I have not seen the clean up work at the interval
  > you
  > > mention. I am curious to find out what your experience is.
  > Is
  > > this 125-minute cleanup a new feature in 8i?
  > >
  > > Thanks,
  > >
  > > Gaja.
  > >
  > --
  > Author: Gait, Christopher
  > INET: cgait_at_condor.nrl.navy.mil
  >
  > 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: ListGuru_at_fatcity.com (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
  > also send the HELP command for other information (like
  subscribing).

  ---

Gaja Krishna Vaidyanatha | gajav_at_yahoo.com 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. http://im.yahoo.com/

-- 
Author: Gaja Krishna Vaidyanatha
  INET: gajav_at_yahoo.com

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: ListGuru_at_fatcity.com (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