Home » RDBMS Server » Performance Tuning » Execution time differences between environments (Oracle 10g/Windows2000)
Execution time differences between environments [message #301768] Thu, 21 February 2008 11:04 Go to next message
gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA
Senior Member
Hi,
we are moving some of the procedures from development to testing environment. In the development, it is running as we expected. but in testing environment, it is taking more time even when we have same data. We have requested DBA to check all the initialization parameters between the databases. Apart from this what are all the things to be taken in account?

//Thangam
Re: Execution time differences between environments [message #301770 is a reply to message #301768] Thu, 21 February 2008 11:11 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
are object statistics current for the testing DB?
Re: Execution time differences between environments [message #301772 is a reply to message #301768] Thu, 21 February 2008 11:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Are execution plans different?

Regards
Michel
Re: Execution time differences between environments [message #301773 is a reply to message #301772] Thu, 21 February 2008 11:41 Go to previous messageGo to next message
gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA
Senior Member
Statistics are upto date but I did not see the complete execution plan. Because it is very difficult to take out sql's in command mode to see the exection plan since it very very complex query involving so many functions, pl/sql tables. Now I am trying to see the execution plan by modifying the sql. any other input??
Re: Execution time differences between environments [message #301774 is a reply to message #301768] Thu, 21 February 2008 11:56 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SQL> ALTER SESSION SET SQL_TRACE=TRUE
then run the results through TKPROF using EXPLAIN qualifier
Previous Topic: Whey sometimes using Exists Function is better
Next Topic: Pivoting or Cross Tab Report
Goto Forum:
  


Current Time: Wed Dec 04 17:36:05 CST 2024