Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: rename table

RE: rename table

From: H elp_me <good_dba_at_hotmail.com>
Date: Mon, 11 Oct 2004 17:02:50 +0000
Message-ID: <BAY14-F367l9OtRDLaR0001395a@hotmail.com>

 

Hello Seema,

In addition to all these.. if you have created outlines, (optimizer plan stability) could be the cause.

HTH Nik >From: <arul.kumar_at_bt.com> >Reply-To: arul.kumar_at_bt.com >To: <oracledbam_at_hotmail.com> >CC: <oracle-l_at_freelists.org> >Subject: RE: rename table >Date: Mon, 11 Oct 2004 15:19:42 +0100 >>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



Find the music you love on MSN Music. Start downloading now![1] Received on Mon Oct 11 2004 - 11:58:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US