When running Toad 8.6.0.38 and trying to connect to an Oracle 10g database, Toad appears to hang.
Please make sure that stats are current. DBAs must gather stats manually on 10g with these two commands:
exec dbms_stats.gather_dictionary_stats;
exec dbms_stats.gather_fixed_objects_stats;