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