RE: rename table

From: <arul.kumar_at_bt.com>
Date: Mon, 11 Oct 2004 15:19:42 +0100
Message-ID: <83FC2D1BC95D884894735B11B562A41C083779FA@i2km06-ukbr.domain1.systemhost.net>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Seema Singh Sent: 11 October 2004 15:10
To: oracle-l_at_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 Received on Mon Oct 11 2004 - 09:14:18 CDT