Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i0UANZD07532 for ; Fri, 30 Jan 2004 04:23:35 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i0UANWo07516 for ; Fri, 30 Jan 2004 04:23:33 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5DB57394918; Fri, 30 Jan 2004 05:20:45 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 30 Jan 2004 05:18:53 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from MXR-1.estpak.ee (mta2.mail.neti.ee [194.126.101.111]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 656C2394BC0 for ; Fri, 30 Jan 2004 05:18:33 -0500 (EST) Received: from localhost (reha1 [127.0.0.1]) by MXR-1.estpak.ee (Postfix) with ESMTP id 05D253559E for ; Fri, 30 Jan 2004 12:24:43 +0200 (EET) Received: from MXR-1.estpak.ee ([127.0.0.1]) by localhost (reha1 [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22538-01 for ; Fri, 30 Jan 2004 12:24:42 +0200 (EET) Received: from porgand (213-35-167-154-dsl.kjj.estpak.ee [213.35.167.154]) by MXR-1.estpak.ee (Postfix) with SMTP id 759CB354E5 for ; Fri, 30 Jan 2004 12:24:38 +0200 (EET) Message-ID: <017d01c3e71b$43ee9bb0$72f923d5@porgand> From: "Tanel Poder" To: References: <20040129211859.GA5805@mladen.wangtrading.com> Subject: Re: temporary tablespace Date: Fri, 30 Jan 2004 12:24:38 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at neti.ee X-archive-position: 394 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tanel.poder.003@mail.ee Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l 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" To: Sent: Thursday, January 29, 2004 11:18 PM Subject: Re: temporary tablespace > On 01/29/2004 04:10:06 PM, Reginald.W.Bailey@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@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@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 -----------------------------------------------------------------