Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Slow UDF when using ojdbc6.jar version 11.2.0.3.0

989537Feb 6 2013 — edited Oct 15 2014

When using Oracle JDBC driver version 11.2.0.3.0 (ojdbc6.jar), a User Defined Function (UDF) is taking over 5 seconds to run. When using the 11.2.0.2.0 driver the same UDF takes less than 50ms. The Oracle database server is running 11.2.0.2.0.

My application calls several different Oracle databases, which are running different versions of Oracle...hence the reason for the mismatch on my driver and server versions.

Is it OK to use the 11.2.0.3.0 driver, when calling a server running 11.2.0.2.0? Has anyone else seen a similar issue? Any ideas on what may be causing this? Or any ideas on what to check?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2013

Added on Feb 6 2013

#database-connectivity-discussions

3 comments

687 views