Is there any way to submit tuning tasks without losing/blocking the rest of toad for the default 1800 time limit? If not or even if you can, another Show SQL button would be a nice alternative so we can paste to an editor and shell it out to SQLPlus. I sometimes want to submit multiple variations and look at the results later. I've scripted most of this to pull it out of SGA and submit and/or accept in batches. Our apps are mostly VPD driven from (restricted to) Active Directory+Kerberos accounts. I've made an extra tuning equipped role that I can add when activating our VPD context procedure so I can do all of this in Toad after login with a non-threaded session. All that just to say, this is a very useful piece of Toad. I just need it to do more faster.
Hi Chuck. Sure, good idea.
Next beta:
The button defaults to "show sql", but also remembers the last thing you used. That way you don't have to click the dropdown arrow every time.
Also, if you leave the default task name, Toad will generate a new one after sending to sqlplus or editor. That way you can just modify the sql and run it again.
-John