1 Reply Latest reply: Jan 29, 2013 11:37 AM by rp0428 RSS

    Oracle 10g - query is very slow in jdbc but not in other tools

    987717
      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;