I have an "Optimize Current SQL" open and have saved the optimizer session to a file. I want to send this file to another DBA so they can work with it.
Where is the saved optimizer session file located on my workstation?
The sessions that are saved are located in the directories listed below. To send the session to another user, you will need to zip up the session folder for that particular session and send it to them. The folders or files do not use the name that you gave it within Toad. The best way to locate the correct session is by timestamp.
C:\Documents and Settings\<User>\Application Data\Quest Software\Toad for Oracle\x.x\SQLTuning for Windows XP
OR
C:\Users\<User>\AppData\Roaming\Quest Software\Toad for Oracle\x.x\SQLTuning for Windows 7
x.x is the version of Toad you are using.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center