When pressing F9 to execute SQL containing a bound variable, there is a delay until the variable input screen appears. With v. 9.7.2 this was nearly instantaneous, but with v. 10.1 it is now taking 10 sec. to appear. It seems like the delay keeps increasing over time. This does not seem to be dependent on the complexity of the SQL. Without bind variables, it runs almost instantaneously.
Variable.dat file is too large.
Go to C:\Documents and Settings\<personal folder>\Application Data\Quest Software\Toad for Oracle\10.0\User Files and rename/remove the variables.dat file.
Toad should be overwriting the file, and not appending, so it should not be growing over time. However, if your run a very large script with lots of bind variables, the file can get quite large, and slow down the prompt for variables window when working in the editor.
