Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> query taking long time from java code

query taking long time from java code

From: <palak123i_at_gmail.com>
Date: 25 Aug 2006 22:19:20 -0700
Message-ID: <1156569560.557565.113370@b28g2000cwb.googlegroups.com> 





We have a struts based UI. Database is oracle 9i. Few queries are
taking around 5-15 seconds to execute from TOAD. But the same query
from java code (using prepared statement) takes around 3 mins... We
have used hint as CHOOSE in both (Toad and Java).



Any pointers please?


Thanks.
Received on Sat Aug 26 2006 - 00:19:20 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US