SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Execution time - difference between SQL Developer and Hibernate

695012Aug 5 2010 — edited Aug 6 2010

Hi,

I have problem with long execution time by Hibernate (JDBC). My very long SQL query (4000 chars) in SQL Developer is executing in 60sec. But this same SQL query via Hibernate (used by ScrollableResult) is executing in above 1000sec. and time is growing up. I see execution time in user session, so I suppose, that is no problem in communication Hibernate - Oracle.

Other interesting thing. I connect to copy of dump this DB in other machine and it's OK. Maybe this problem is in Oracle setup or parameters?
Oracle ver. 9.2i.

Thanks for any suggestion.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 3 2010

Added on Aug 5 2010

5 comments

2,372 views