We are using the JDBC adapter to invoke a stored procedure on Oracle (using the stored procedure template). The problem is that Oracle seems to be using a lot of CPU (it’s on a separate server), and processing very slowly. We’re only processing about 6 docs/sec with 3 ISes in a cluster.
The webMethods service simply takes a document off a queue, invokes the STP. The STP just inserts data into a table.
The DB experts informed us that webMethods is invoking the stored procedure in a way that causes the stored procedure to be loaded and parsed each time the service is run. webMethods TS have confirmed that webMethods uses a Callable statement and that we cannot change the way webMethods behaves in this regard.
Has anyone seen this type of issue before and/or worked around this?
What kind of performance have you seen inserting into Oracle?