query execution is slow, displaying query results is slower

by Jul 31, 2012

the DB is Oracle 11. I can run a query in .212 seconds in Oracle SQL Developer, it takes one minute thirty six seconds in ADS v 10. I've tested v 11 and it does not seem much better. Also, I often have it report that the query completed with zero errors, but it takes another thirty to forty seconds to display any results. What could I be doing wrong?