From oracle-l-bounce@freelists.org Mon Oct 11 09:14:18 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9BEEIr21258 for ; Mon, 11 Oct 2004 09:14:18 -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 i9BEEII21251 for ; Mon, 11 Oct 2004 09:14:18 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8C14172C72F; Mon, 11 Oct 2004 09:20:24 -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 30900-57; Mon, 11 Oct 2004 09:20:24 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EED7272C590; Mon, 11 Oct 2004 09:20:23 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: RE: rename table Date: Mon, 11 Oct 2004 15:19:42 +0100 Message-ID: <83FC2D1BC95D884894735B11B562A41C083779FA@i2km06-ukbr.domain1.systemhost.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: rename table Thread-Index: AcSvnFen06+W/4S3QPGLAjIxTd3MLwAAKeWQ From: To: Cc: X-OriginalArrivalTime: 11 Oct 2004 14:19:43.0164 (UTC) FILETIME=[5A392FC0:01C4AF9D] X-archive-position: 10904 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: arul.kumar@bt.com Precedence: normal Reply-To: arul.kumar@bt.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Seema,=20 Possible reasons could be: 1. Optimizer statistics are not available. May have to update them = ACCURATELY again. 2. All the SQLs are being parsed again freshly (taking more time!), as = the cached versions are invalidated. 3. Check for "validity" of all the dependent objects. May be some = indexes are invalid and not usable, resulting in poor performance. HTH Arul. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Seema Singh Sent: 11 October 2004 15:10 To: oracle-l@freelists.org Subject: rename table=20 Hi, I have some issue with rename. There are 2 tables which I want to rename.Let us name as table1 and = table2. The moment I renamed these tables the site became slower.AFter rename I=20 rebuilded indexes and validate structure too.But still I noticed site=20 slower.The only diffrent I noticed the diffrent name of indexes.aNy = thought=20 ???? thanks -Seema _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's = FREE!=20 http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l