I have a query I want to explain using SQL Optimizer. I am connected to the database I want to explain it in in Toad and hit the optimizer button but when it invokes SQL optimizer it is in another database (which happens to be a production database).
A couple questions:
Do you have the production database connection defined in the Toad Connection Manager?
Was SQL Optimizer already running when you invoked it from Toad, or did Toad launch the application?