query slowdown

[Robert Boyle]

hi there wondering if anyone can shed any light on this prob i am having:

environment:
java 1.4
ojdbc 10.2.0.2
oracle 10.2
weblogic 9.1

have a query running sub second on sqlplus and through a test class i generated to use jdbc. however in the application it is taking 20secs and is taking this time once accessing the jdbc method ps.executeQuery(). Other queries (the same query without a predicate being added) runs sub second on the app so i am mighty confused.

Anyone? thanks in advance.

R.

[Sivaraman Lakshmanan]

Hi,

Check if the predicate is doing some costly operations on charater field. We can help you more if you can post both the queries.

Regards,
Sivaraman.L