Hi,

It's hard to give an explanation without knowing your code and data but most
of the time when i receive problems like this (works on QA but not on
application) it's because of inproper plan usage. I run the same statement
with same parameter on QA it works fine but the sp suffers when it called
from application. I have found that there are 2 plans cached for that sp in
syscacheobjects. (Because of set options are different). And i found that
because of data distribution when the sp executed for the first time the
generated plan is optimal for that parameter value but if the sp is called
for other parameter values that plan is not optimal and suffers. So we use
with recompile if it's acceptable or change the code.
Not sure that this is your problem but might give you a hint..
Regards.



"vineet.jsl (AT) gmail (DOT) com" wrote: