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" - Unknown
Received on Fri Jul 28 2006 - 13:52:09 CDT
