This content has been marked as final. Show 2 replies
user4908334 wrote:More information is needed on that.
We are in the process of converting an ASP web application running on IIS to a java web application running on OAS. We have java code using a CallableStatement that calls an Oracle PL/SQL Procedure that runs inserts and updates as needed and does not return anything.
There is one proc or 50?
The proc is being called one time or 50 times?
You are not using Batching right?
When the procedure is called from IIS with the exact same parameters that were used from OAS the procedure ALWAYS runs in 3 minutesYou are running the java server on exactly the same box as IIS?
The java code is using exactly the same database as IIS? (Did you verify this?)
Thanks for the quick response.
There is one proc or 50? 1 proc
The proc is being called one time or 50 times? The proc is called one time.
You are not using Batching right? Correct.
You are running the java server on exactly the same box as IIS? Java and IIS servers are on different boxes. Being on different servers shouldn't matter since the slow performance is inside the database.
The java code is using exactly the same database as IIS? Yes, both IIS and java using same database. We write parameters and timing lines to a logging table. Log entries showing up for runs from both servers.