Hi All,
Just want to confirm this, we have a Stored procedure that takes a long time to execute, something like 3 to 4 hours, it contains its own logic. If we call it from a biztalk orchestration using the Oracle adapter or a component calling it and we call that component. Once the SP is invoked it obviously executes on the Oracle Server, so all the performance load would be on that server, and the load on BizTalk server would be only that it would be waiting for that call to complete and maintaining the state of that orchestration and nothing else?
We want to confirm this because if the load of executing SP for three hours is on BizTalk then we'd look for alternate ways of doing this.
Regards,
Sajid.