| Execution time differences between environments [message #301768] |
Thu, 21 February 2008 11:04  |
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 #301773 is a reply to message #301772] |
Thu, 21 February 2008 11:41  |
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??
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
