From oracle-l-bounce@freelists.org Wed Oct 27 13:26:56 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9RIQtl19083 for ; Wed, 27 Oct 2004 13:26:55 -0500 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 i9RIQsI19068 for ; Wed, 27 Oct 2004 13:26:54 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 03B5372EA91; Wed, 27 Oct 2004 13:33:06 -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 27407-62; Wed, 27 Oct 2004 13:33:05 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 50BDB72D9D6; Wed, 27 Oct 2004 13:33:05 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=N0sxvN+s87GQvCldU55ux/WHQ3Rsbktjl8BpuyV9Gzq0ditW417tGZyOzZoRoDciReG3r/vUMUWCVoeq1bD/i2fnglE259E7pti66jCqlM9zN8V8zk5Hyxg/+onRm7kpaeiDWezvw6oTs/qigqv9bJ7J7bq62EOWDOvYeKIqXjk= Message-ID: <9177895d04102711317a8e50b5@mail.gmail.com> Date: Wed, 27 Oct 2004 14:31:14 -0400 From: rjamya To: thomas.mercadante@labor.state.ny.us Subject: Re: TEMPORARY TABLE Cc: "oracledbam@hotmail.com" , oracle-l@freelists.org In-Reply-To: Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: X-archive-position: 11601 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rjamya@gmail.com Precedence: normal Reply-To: rjamya@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org well tom is almost 99% there ... there is the rest of the story ... about GTTs that 1. you better use dynamic_sampling with them 2. any even one session is useing it, you can't perform most DDLs 3. forget doing truncates on them, KGopal probably has the proof. otherweise they work almost as advertised ... Raj On Wed, 27 Oct 2004 14:20:03 -0400, Mercadante, Thomas F wrote: > Seema, > > I use Global Temporary Tables all the time. They are memory structures. > Very fast. Very easy to set up. No problems at all. > > Good Luck > > Tom Mercadante > Oracle Certified Professional > > > > > -----Original Message----- > From: Seema Singh [mailto:oracledbam@hotmail.com] > Sent: Wednesday, October 27, 2004 1:34 PM > To: oracle-l@freelists.org > Subject: TEMPORARY TABLE > > Hi, > Is any performance problem if we go with TEMPORARY table? > any thoughtS? > thx > > _________________________________________________________________ > Express yourself instantly with MSN Messenger! Download today - it's FREE! > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > > -- > http://www.freelists.org/webpage/oracle-l > -- > http://www.freelists.org/webpage/oracle-l > -- ------------------------------ -- http://www.freelists.org/webpage/oracle-l