Can't avoid the "Please Wait" window for long running queries/results
説明
When running a query, the "Please Wait" window comes up and locks up Toad so that no other work can be done while the query is running and this window is up.
Is there any way of closing this window or preventing it from coming up?
原因
Using F5 Execute as Script will bring up this window when there is a lot of data to access. This is not based on an option setting. This is because of the way data is retrieved from the database and outputted to the SQL Editor when running as a script.
対策
To avoid the Please Wait window, run queries individually using F9 Execute as Statement (instead of F5 as a script).
NOTE: The "Please Wait... Accessing Data" window is different from the "Processing Statement" window. Please see attachment for screen shots of the different windows.
The "Processing Statement" window is enabled and disabled by the View | Options | Oracle | Transactions | Execute Queries in Threads option setting. Please refer to solution 18125 for more information about this: https://support.quest.com/SUPPORT/index?page=solution&id=SOL18125
