QUESTION POSED ON: 28 July 2003
Does Oracle 9iR2 release temporary tablespace that
is no longer being used? I am running it on Red Hat
Linux (not Advanced Server). I only notice it being
released for use again when I shut down the database
and start it up again. The tablespace still exists
at the high water mark it hit, but it is available
for use in its entirety, again.
If it does not release, what would you recommend for running a series of processes that use a lot of the
space iteratively on a server with limited disk?
I have a temp tablespace create script that I could
run between steps that creates "temptemp", sets it
to the default, drops temp, creates temp, sets it to
the default, then drops temptemp.
The problems with this are it takes time to claim
disk back up the the high water mark, it takes time
to execute this script, etc. Ideally, Oracle should
release the space for new sorts or whatever once
the prior sort has finished, but I'm not seeing that
happen. I am monitoring it in OEM, so perhaps it is
happening but not registering in that GUI.
Any insights, advice, or resources you can point me
to would be appreciated.
|
