You can also have multiple datafiles making up your TEMP tablespace
(which can be offlined, droped and recreated - tricky), or use a
tablespace group made up of multiple tablespaces. Either option allow
you to resize the TEMP tablespace without droping it - which saves you
the trouble of reassigning the default tablespace for your users.
However, this should not be part of your regular procedure, as you are
downgrading the performance of Oracle. There is a reason why Oracle
does not waste time deallocating the space taken by the TEMP segments -
it is to avoid having to use more resources to allocate more segments
the next time you need them.
You basically have two distinct issues: - how much temp space a certain
process consumes (may be worth reducing), and - freeing up allocated
temp space (typically should be avoided, unless the TEMP files didn't
have an appropriate maxsize)
My opinion
Received on Tue Sep 12 2006 - 06:33:59 CDT
