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"
Received on Mon Jun 19 2000 - 17:20:12 CDT
