Re: temporary tablespace
- From: "Tanel Poder" <tanel.poder.003@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 30 Jan 2004 12:24:38 +0200
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@xxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, January 29, 2004 11:18 PM
Subject: Re: temporary tablespace
> On 01/29/2004 04:10:06 PM, Reginald.W.Bailey@xxxxxxxxxxxx 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
