I am trying to batch optimize a rather complex SQL statement and I have getting “No valid SQL found” I believe I have a configuration problem on my PC but am not sure where to look.
I am using the batch optimize SQL option and using “SQL Text”. I put my SQL in and it starts scanning then stops at 1% stating No valid SQL found.
- Quest SQL Optimizer for Oracle 22.214.171.1241 Enterprise
- Windows 7 64bit
- Oracle Instant Client 11.2 64 bit
When I try to perform the same steps using Windows 7 XP Mode with XP 32bit , 32bit oracle drivers the SQL is found and it attempts to optimize it.
What can I do to figure out what is not configured correctly in order to have SQL Optimizer work with windows 7 64bit with 64bit Oracle Client?