Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
General Database Discussions
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jan 29, 2013 11:37 AM by
Oracle 10g - query is very slow in jdbc but not in other tools
Jan 29, 2013 1:21 AM
I'm using PreparedStatement to execute a query with some parameters.
in sql developer, it just spends 12 seconds but in jdbc, it's around 140 seconds.
I disabled "_optim_peek_user_binds" parameter already but it didn't help.
alter session set "_optim_peek_user_binds"=false;
This content has been marked as final.
Show 1 reply
Re: Oracle 10g - query is very slow in jdbc but not in other tools
Jan 29, 2013 11:37 AM
in response to
Please mark this thread ANSWERED and repost it in the JDBC forum.
When you post provide your 4 digit Oracle version, Java version and JDBC jar name and version as well as the code you are using.