Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: rename table
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
![]() |
![]() |