Oracle 9.2.0.7 and it is temporary tablespace,
And how could we come to know when to go for deallocate or colesce.
Brian Peasland wrote:
> 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 Sun Jul 30 2006 - 11:21:33 CDT
