RE: rename table

From: Mark Richard <mrichard_at_transurban.com.au>
Date: Tue, 12 Oct 2004 08:06:12 +1000
Message-ID: <OF3D1D7224.B466C43E-ONCA256F2A.00794898@transurban.com.au>

There is also the possibility that the queries had hints referring to particular indexes / tables. For example, parallel hints referring to the original table name (if not using an alias) would be ignored.

                                                                                                                                       
                      <arul.kumar_at_bt.com                                                                                               


                      >                         To:       <oracledbam_at_hotmail.com>                                                     

                      Sent by:                  cc:       <oracle-l_at_freelists.org>                                                     
                      oracle-l-bounce_at_fr        Subject:  RE: rename table                                                             
                      eelists.org                                                                                                      
                                                                                                                                       
                                                                                                                                       
                      12/10/2004 00:19                                                                                                 
                      Please respond to                                                                                                
                      arul.kumar

Seema,=20

Possible reasons could be:

Optimizer statistics are not available. May have to update them = ACCURATELY again.
All the SQLs are being parsed again freshly (taking more time!), as = the cached versions are invalidated.
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





<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone.
In such a case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999.
Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 11 2004 - 17:03:51 CDT