I recently upgraded to Toad 4.0 and now it seems to lock up occasionally. A couple times a week.
Typically the DBA will ping me saying I’m running a query without a where clause. I am always surprised, but TOAD is submitting the following query.
SELECT * FROM ------ LIMIT 40.
Once I manually kill the above query TOAD unfreezes and runs the query I submitted.
I have now learned to recognize this before the DBA pings me. So I kill the above query as fast as I can and everything works normally.
Why is TOAD doing this and is it an option I can turn off?