RE: Locally Managed Tablespace Survey

From: Gaja Krishna Vaidyanatha <gajav_at_yahoo.com>
Date: Thu, 22 Jun 2000 19:08:56 -0700 (PDT)
Message-Id: <10536.110214@fatcity.com>

Gopal,

What I have been trying to communicate all along is that the issue of periodically cleaning up "temp segments" is not relevant for temporary tablespaces of type "TEMPORARY". There is only 1 temp segment for the entire tablespace and it gets dropped on shutdown. The concept of periodic cleaning is not relevant here.

Further, on instance startup, the first sort that is greater than sort_area_size allocates the temp segment on disk and this grows subject to the size of the temporary tablespace. In my communications I have been using the term "true temporary tablesapces" and this is what I have been referring to - temporary tablespaces of type TEMPORARY. What you are talking about is for temp segments that get created during creates, rebuilds or sorts on disk to tablespaces of type - PERMANENT.

Hope that helps,

Gaja.

• kgopalakrishnan <kgopalakrishnan_at_mantraonline.com> wrote:> Hi Gaja !
  >
  > >
  >>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.

> If my memory serves right there is an > intenral event called
"DROP_SEGMENTS"
> (can be used with alter system i guess)
> which FORCES the cleanup in temp segments.> >
> K Gopalakrishnan
> Bangalore, INDIA
> http://www.geocities.com/kgkrish

---

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!?
Get Yahoo! Mail - Free email you can access from anywhere! Received on Thu Jun 22 2000 - 21:08:56 CDT