First Call To DB Adapter Takes About 20 Seconds

(Doc ID 1919939.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Service Bus - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

In OSB a simple business process is used that calls a database procedure defined in a package inside an Oracle DB.

When running the OSB server with JRockit 1.6, depending on the number of characters in name of the database package, a difference in elapsed time can be seen for the first call of the procedure after a server start.

With the package name TESTPKG (odd number of characters), the first call of the procedure after the server start returns in around 3 seconds, while subsequent return almost immediately. This behavior is expected, since class loading needs to be performed with the first call. But when the package name is TEST_PKG (even number of characters), the elapsed time for the first call is around 5 to 6 times higher (around 16 seconds).

Note 1: This somehow strange issue applies to all other JCA properties as well.

 

Note 2: When using HotSpot JDK instead of JRockit, there is no such difference depending on the name.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms