Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: use temporary tablespace details
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.........
Which version of Oracle? Was your tablespace created with TEMPFILES or
DATAFILES?
Cheers,
Brian
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Fri Jul 28 2006 - 13:52:09 CDT