|
|
|
|
Re: Stored Procedure is taking too long time to Execute. (2 Merged) [message #497304 is a reply to message #497293] |
Fri, 04 March 2011 15:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
nanuvamsi wrote on Fri, 04 March 2011 21:17Can you please suggest what might be the reasons.
One database having six times the data of the other one.
or
One database server having six time the processing power of the other one.
or
Something that will show up in a trace or perhaps an explain plan.
|
|
|
|
|