Hey Job, >> Oracle Tuning Advisor seems to be limited to those statements already >> executed. >> I haven't seen a way to manually enter a statement to tune. > > You can manually enter your own statements, you don't need to retreive > them from the cache. It's covered in the docs. > > The advisor can be run on one SQL Tuning Sets, and SQL Tuning Sets can be > created from a SQL Repository, which is nothing more than a table you > create that contains some custom SQL statements in it, regardless of > whether they were executed or not.. There is also an API to create a STS > from your own statements as well, if you don't want to use the GUI. Hmmm...your argument seems to prove my point about OEM not having an interface for ad-hoc SQL in the Oracle Tuning Advisor. Thanks! Rich -- //www.freelists.org/webpage/oracle-l