Re: Question for PeopleSoft DBAs out there

From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Tue, 22 Jan 2008 09:23:32 -0600 (CST)
Message-ID: <10340.12.17.117.251.1201015412.squirrel@12.17.117.251>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 22 2008 - 09:23:32 CST

Original text of this message