Re: temporary tablespace

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Fri, 30 Jan 2004 12:24:38 +0200
Message-ID: <017d01c3e71b$43ee9bb0$72f923d5@porgand>

Hi!

In later Oracle versions where workarea sizes for executing even identical statements can change considerably due automatic workarea management and your temporary tables can be swapped into temp tablespace from PGA, it actually might be worth-while to create temp TS as autoallocate.

So far I've sticked with uniform, though.

Tanel.

Original Message ----- From: "Mladen Gogala" <mladen_at_wangtrading.com> To: <oracle-l_at_freelists.org> Sent: Thursday, January 29, 2004 11:18 PM Subject: Re: temporary tablespace

> On 01/29/2004 04:10:06 PM, Reginald.W.Bailey_at_jpmorgan.com wrote:
> >
> > How do you make sort_area_size dynamically autoallocate large chunks
> > of
> > memory?
> >
>
> You don't. And you don't create temporary tablespace with autoallocate,
> either.
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jan 30 2004 - 04:24:38 CST