Hi, Toad has been working fine, for years. Then all of a sudden, randomly, certain queries are taking 10 - 15 seconds to return. I can run the same query 5 times, and 2 out of 5 return instantly, and the other 3 take enough time that the software says "Not Responding".
This is true for browsing tables also. Even selecting from DUAL or from V$SESSION has the same behavior.
Has anyone else had this happen? I was running version 10, and upgraded to 13.3, and the behavior persists.......
Thoughts?
If it happens in both 10 and still 13.3, I'm guessing it's something in your environment and not Toad. Sounds like you are getting timed out somewhere upstream. Usually database timeouts give an Oracle error message right away and not a long hang, so maybe the server where the database resides is cutting the connection, or something else on the network. That's what it feels like to me.
Hmm, it only started a few days ago. And, no ORA- messages are given, and eventually the query finishes, it just takes 10 - 15 seconds. Others that use SQL Developer are not having this issue, and things done from SQL Plus at command line from Linux are not having any issues either. I was leaning towards something that changed in my Windows environment. Would that be possible?
Maybe? I don't have any ideas, sorry.
Maybe some file has grown very large in Toad's user settings folder.
You can try resetting the settings (described here).
If that doesn't work, you can restore the old settings.
If that does work, could you zip up and email me the user settings folder that caused the problem? Send to john.dorlon@quest.com
Thanks.