SQL running slow when executed thru java

Question

I am trying to execute a query in oracle db. When i try to run thru SQLTools the query is executing in 2 seconds and when i run the same query thru JAVA it is exectuting in more than a minute.

I am using a hint /*+ordered use_nl (a, b)*/

I am using ojdbc6.jar Is it because of any JARS? Please help whats causing this?

A simple example could be useful. Also, are you measuring just the time for the query or some sort of JVM startup time as well? — Mattias Nilsson
– Mattias Nilsson, Commented Jun 18, 2010 at 8:16
hints are irrelevant unless you post the query, and perhaps the explain plan for both the unhinted and hinted versions of the query. — Jeffrey Kemp
– Jeffrey Kemp, Commented Jun 18, 2010 at 10:01

user326503 · Accepted Answer · 2010-06-18 08:17:26Z

1

For Oracle 9i or later, database engine can tune SQL automatically, few case need to specify hints.

How do you run query in Java, repeat to run in loop? use parameter? prepare before execute?

answered Jun 18, 2010 at 8:17

user326503

Sign up to request clarification or add additional context in comments.

2 Comments

user270885 Over a year ago

I am running thru preparedstatement

user326503 Over a year ago

Do you measure one minute time in which statement? 1. preparestatement() 2. execute() 3. while (resultSet.next()) 4. // do something cost one minute in which step?

b.roth · Accepted Answer · 2010-06-18 08:18:37Z

0

You need to profile your Java application to identify where in the Java code before or after the SQL execution that overhead time is being spent.

Some profiling tools that you can use for that are: YourKit, JProfiler and HPROF (this one is a command line tool).

answered Jun 18, 2010 at 8:18

b.roth

9,5708 gold badges40 silver badges50 bronze badges

1 Comment

b.roth Over a year ago

Why was my answer downvoted? You really need to run a profiler to find out why it takes a minute to run the SQL via your Java app. I doubt that it is in Oracle that it is taking over a minute, since it only takes 2 seconds from SQL Tools.

Collectives™ on Stack Overflow

SQL running slow when executed thru java

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related