Oracle Database Discussions

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 statement is running fast in SQL plus but not in Toad or SQL developper

690159Mar 10 2009 — edited Mar 19 2009

I have a conplex sql statement that have used distinct, union, many table joins, this query is running fast from sql plus on server(10.2.0.3) and from my client machine's sql plus (10.2.0.1), start to receive query output in 50 seconds, it does take 8-9 minutes to display all output. But when using any tool, like toad(9.7.2.5), discover, sql developer, it is extremely slow.

Any one has any idea what is wrong here? I know those tool need some extra time to do the format and display everything at once, but it shouldn't wait 4 hours and i still not able to produce the output? is there any way to correct this?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2009

Added on Mar 10 2009

#general-database-discussions

30 comments

2,962 views