Old desktop: Windows 7, Toad for Oracle Xpert v 12.1 with DB Admin Module. Simple query, Optimization works fine when run in Toad for Oracle Editor Window. 400 rewrites checked, 53 to be tested, many better alternatives found already.
New desktop: OSX El Capitan with Crossover, Toad for Oracle Xpert 12.10 with DB Admin module. Same query, optimization fails as follows.
When run from Toad for Oracle Editor Window:
“No better alternatives found” 0 of 0 tested. (1 rewrites checked)
When run from Dell SQL Optimizer for Oracle 9.2.1 window, error “Failed to retrieve scenario explain plan” OLE 80004001 (even though I generated an Explain Plan under Toad.