Return
-
Title
Toad randomly hangs after executing a SQL query -
Description
After running a query that brings back about 10K rows, randomly at times Toad hangs as if it's trying to process something or run something. Not able to stop the process so forced to kill Toad Data Point. -
Cause
Environment Related: Toad can freeze when running a full table scan of a 30 column tabe that has several millions of rows data.CAUSE 1:If using the Code Completion in Toad; Toad will perform a Select * from a table (full table scan) when generating distinct literals.(For example: building a where condition filter on right had side. i.e. address_id = ... at the cursor, code completion will generate a list of distinct values from the table in question performing a full table scan.)CAUSE 2:If the Data Browser data tab is open. If in the editor and executing a DDL statement which triggers full refresh on the browser. -
Resolution
WORKAROUND 1:Disable Code Completion to eliminate the conflict in Cause 1.1. In the main Menu, go to Tools | Options.2. In the new window, on the left side go to Editor - Code Completion.3. On the right side, un-check the option "Auto pop-up after".4. Click Apply and OK and re-test the issue to see if it happens again.WORKAROUND 2:In the Object Explorer any object selected goes to the View Details tab by default; do not do the following when performing tasks such as SQL queries or procedure executions, etc.a. Do not select the Data tab and leave it open in the Data tab.b. Do not right-click an object and select Browse Data and leave that window open.This will prevent Toad doing a full refresh query (full table scan) on the selected object in the Object Explorer.