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.........
Kenneth wrote:
> On 28 Jul 2006 02:16:12 -0700, "aman.oracle.dba"
> <aman.oracle.dba_at_gmail.com> wrote:
>
> >I want to know where else temporary tablespace is used excluding
> >sorting.
> >Please tell me if document on net which tells everything which uses
> >temporary tablespace and why.(example : EXP)
> >
>
>
> http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm
>
> or more specifically
>
>
> http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14220/logical.htm#sthref425
>
> This is called the Oracle Concepts Manual.....which is the place to
> look when you're having such basic questions.
>
>
> - Kenneth Koenraadt
Received on Fri Jul 28 2006 - 13:12:50 CDT
