I’ve downloaded and using trial version of Toad For Oracle version 22.214.171.124 from Toad DBA Suit For Oracle edition.
I’ve downloaded this version approx. 2 months back and have extended the license (trial period) also.
But a very disappointing problem is that since its installation, it has not given any output for a single SQL optmization.
Whenever I try to optimize any sql, it runs for several hours and “Not Responding” is written in the title bar.
I’ve also tried “Stop if optimization exceeds “N” minutes” (where N = 30 or similar) but even after that time, it does not run the alternative SQL statements that it has suggested.
Microsoft Windows 7.
Intel Core i3 @ 3.30GHz
4 GB RAM (2.85 usable)
Oracle Client 11 and Oracle Server 11.