Home » RDBMS Server » Performance Tuning » Reproduce performance problem in test (Oracle 9i)
Reproduce performance problem in test [message #295799] Wed, 23 January 2008 08:47 Go to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
Is there a way I can have the explain plan same in dev as prod, it changes because of data. Do stats import on tables will help.

Please help.
Re: Reproduce performance problem in test [message #295806 is a reply to message #295799] Wed, 23 January 2008 09:04 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

It should be work.
Re: Reproduce performance problem in test [message #295901 is a reply to message #295806] Wed, 23 January 2008 20:59 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Search the documentation for OUTLINEs and Plan Stability.

Also check DBMS_STATS. It is possible save and replace stats.

Ross Leishman
Previous Topic: bitmap conversion in explain plan
Next Topic: Index hint inside the view is not working
Goto Forum:
  


Current Time: Sun Dec 11 06:16:02 CST 2016

Total time taken to generate the page: 0.04547 seconds