From oracle-l-bounce@freelists.org Tue Jun 21 07:51:56 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j5LCpo9F032543 for ; Tue, 21 Jun 2005 07:51:55 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j5LCpoNi032539 for ; Tue, 21 Jun 2005 07:51:50 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E8CD51C1357; Tue, 21 Jun 2005 06:48:25 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22611-02; Tue, 21 Jun 2005 06:48:25 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5BF6E1C0CF5; Tue, 21 Jun 2005 06:48:25 -0500 (EST) Message-ID: <4127F81F6CAFC245A18BC49054EFB06302916AA5@ssslexchusr6.sssl.bskyb.com> From: "Barr, Stephen" To: oracle-l@freelists.org Subject: Oversized TEMP space Date: Tue, 21 Jun 2005 12:34:03 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C57655.202E18C4" X-archive-position: 21397 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Stephen.Barr@BSkyB.com Precedence: normal Reply-To: Stephen.Barr@BSkyB.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.0 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------_=_NextPart_001_01C57655.202E18C4 Content-Type: text/plain Are there any possible issues with oversizing a TEMP tablespace? Would it affect any of the costing algorithms? Are there any other downsides other than the small management overhead? ----------------------------------------- Information in this email may be privileged, confidential and is intended exclusively for the addressee. The views expressed may not be official policy, but the personal views of the originator. If you have received it in error, please notify the sender by return e-mail and delete it from your system. You should not reproduce, distribute, store, retransmit, use or disclose its contents to anyone. Please note we reserve the right to monitor all e-mail communication through our internal and external networks. ------_=_NextPart_001_01C57655.202E18C4 Content-Type: text/html Content-Transfer-Encoding: quoted-printable =0D=0A=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A=0D= =0A=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A
=0D=0A=0D=0A

Are there any possible issues with oversizing a TEMP=0D=0A= tablespace?

=0D=0A=0D=0A

 

=0D=0A=0D=0A

Would it affect any of the costing algorithms?

=0D=0A=0D=0A

 

=0D=0A=0D=0A

Are there = any other downsides other than the small=0D=0Amanagement overhead?

=0D=0A=0D=0A
=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A=0D=0A

=0D=0A

=0D=0AInformation i= n this email may be privileged, confidential and is intended=0D=0Aexclusive= ly for the addressee=2E The views expressed may not be official=0D=0Apolicy= , but the personal views of the originator=2E If you have received it=0D=0A= in error, please notify the sender by return e-mail and delete it from your= =0D=0Asystem=2E You should not reproduce, distribute, store, retransmit, us= e or=0D=0Adisclose its contents to anyone=2E

Please note we reserve= the right=0D=0Ato monitor all e-mail communication through our internal an= d external=0D=0Anetworks=2E=0D=0A

=0D=0A=0D=0A=0D= =0A ------_=_NextPart_001_01C57655.202E18C4-- -- http://www.freelists.org/webpage/oracle-l