This discussion is archived
3 Replies Latest reply: Feb 6, 2013 12:37 PM by 989537 RSS

Slow UDF when using ojdbc6.jar version 11.2.0.3.0

989537 Newbie
Currently Being Moderated
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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points