Home » SQL & PL/SQL » SQL & PL/SQL » Performance Issues (Oracle 10g.)
Performance Issues [message #443044] Fri, 12 February 2010 04:24 Go to next message
sanyadu
Messages: 30
Registered: October 2006
Location: Chicago
Member
Hi All,

In DB environment , I have removed all the objects, grants , indexes etc. ( The database have nothing except the schema) and recreated the same from existing scripts. As soon as i did this i got huge performance issues.

Can you please help me what do i need to do get my previous statistics.

Thanks
Sandeep.

Re: Performance Issues [message #443049 is a reply to message #443044] Fri, 12 February 2010 04:38 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
DBMS_STATS.GATHER_SCHEMA_STATS
Re: Performance Issues [message #443051 is a reply to message #443049] Fri, 12 February 2010 04:51 Go to previous messageGo to next message
sanyadu
Messages: 30
Registered: October 2006
Location: Chicago
Member
Already did that still the same performance issues.
It has analyzed all the objects. but performance did not improve.
Re: Performance Issues [message #443053 is a reply to message #443051] Fri, 12 February 2010 04:56 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Oh dear.

My first guess would be that the script that you ran did not recreate all the indexes that you had in the application.

Do you have a backup?
Re: Performance Issues [message #443055 is a reply to message #443044] Fri, 12 February 2010 05:18 Go to previous messageGo to next message
sanyadu
Messages: 30
Registered: October 2006
Location: Chicago
Member
I Used the same scripts which i have in SIT environment. and compared the indexes , they are exactly same. and I don't have issues in SIT environment.
Re: Performance Issues [message #443057 is a reply to message #443044] Fri, 12 February 2010 05:26 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
What's going slow? everything? certain things? We need some more details here.
If you've got particular statements that are running slow then get an explain plan for it, get an explain plan for the same statement on the db that isn't running slow and compare.
Re: Performance Issues [message #443064 is a reply to message #443055] Fri, 12 February 2010 06:27 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Do you have the same data in the two environments?
Previous Topic: encrypt a few filds in the database
Next Topic: model-clause
Goto Forum:
  


Current Time: Thu Sep 29 19:15:46 CDT 2016

Total time taken to generate the page: 0.09175 seconds