Re: use temporary tablespace details

From: joel garry <joel-garry_at_home.com>
Date: 28 Jul 2006 14:33:43 -0700
Message-ID: <1154122423.419604.299150@i42g2000cwa.googlegroups.com>

aman.oracle.dba wrote:
> Actually my database temporary tablespace is increasing very fast day
> by day. I just want to know why and how.... means I thought space is
> deallocated when sorting is over when
> sorting is in auto mode and I have configured
> PGA_AGGERATE_TARGET.............
> or I have to deallocate the space. If yes then how.........

It is only deallocated if you are using a permanent tablespace for your temporary segments. If you are using a temporary tablespace, SMON cleans it up at the next startup (although I've seen some versions not totally clean then, either). See metalink Note:1039341.6 for more details.

Please don't top-post.

--
@home.com is bogus.
Uh, yeah, I'm depressed, test me!
http://www.signonsandiego.com/uniontrib/20060727/news_1c27mushroom.html

Received on Fri Jul 28 2006 - 16:33:43 CDT