When I first start Toad, I can execute any query in milliseconds about 5-6 times, and after that I can get the following issue.
With F9, any query takes ~20 seconds until results show. The query viewer and oracle v$sql view shows the query taking milliseconds.
With F5, ~20 seconds until box pops up stating 'Process Grid output for task 1 of 1', another ~15 seconds until results show.
This issue happens to every database I connect to. SQLplus does not have the issue, every query comes back immediately.
I did a network packet trace and I can see the results come back from the database immediately.
When using a process monitor on Toad during the 20 second pause, I can see about 20% of the cpu being used by thread 1604 at address toad.exe+0x1000.
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