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.

Report message to a moderator

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.

Report message to a moderator

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: 3728
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 10:04:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.