When running some queries using F5, Toad hangs or takes a long time before it return results. This is only a problem when running with F5 Execute Script.
Using F9 or in SQL Plus does not have the same problem. This is also only a problem with some queries.Very short queries that return only a few records will come up quickly. The more records, the slower the results and sometimes it hangs.
Example:
select * from V$SESSION;
-- If this returns 10 rows, it takes about 40 seconds to return results if run with F5. It returns in msec if run by other means.
-- If this returns more rows, it can take minutes to return.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center