Bind variables slowing down sql

Toad for Oracle
1

Hi,

I’m using version 10.1.1.8 on Oracel 10G. When I run a simple sql with a bind
variable, Toad takes at least 10-15seconds to come back and ask for variable
value. But when I put in the variable value directly, the sql runs immediately.

Any ideas why the delay with bind variables?

an example sql could be : select * from clients where client_id = :client_id;

2

This has been resolved. I had to delete the Variables.dat file in the \user
files directory. It had grown to 714kb (still not so big) but was causing this
delay.
image001.jpeg

3

This has been resolved. I had to delete the Variables.dat file in the \user
files directory. It had grown to 714kb (still not so big) but was causing this
delay.
image001.jpeg