RE: rename table
- From: "H elp_me" <good_dba@xxxxxxxxxxx>
- To: oracledbam@xxxxxxxxxxx
- Date: Mon, 11 Oct 2004 17:02:50 +0000
Hello Seema,
In addition to all these.. if you have created outlines, (optimizer plan
stability) could be the cause.
HTH
Nik >From: <arul.kumar@xxxxxx> >Reply-To: arul.kumar@xxxxxx >To:
<oracledbam@xxxxxxxxxxx> >CC: <oracle-l@xxxxxxxxxxxxx> >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@xxxxxxxxxxxxx
>[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Seema Singh >Sent: 11
October 2004 15:10 >To: oracle-l@xxxxxxxxxxxxx >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/
>>-- >//www.freelists.org/webpage/oracle-l >--
>//www.freelists.org/webpage/oracle-l
----------------------------------------------------------------------------
Find the music you love on MSN Music. Start downloading now![1]
--- Links ---
1 http://g.msn.com/8HMBENUS/2755??PS=47575
--
//www.freelists.org/webpage/oracle-l
Other related posts:
