Re: tuning advisor ... again

Akimeu wrote:
> Hi all...
>
> As mentioned in one of my previous posts, we do not have the Enterprise
> Manager installed on our systems. So, I ran the addmreport, and then
> the sql in sqlplus to see the recommended changes. However, there are
> quite a few recommendations that state:
>
> Run SQL Tuning Advisor on the SQL Statement with SQL_ID "blahblah123".
>
> How can I accomplish this throught sqlplus without the EM??? If need
> be, I can install EM on another machine... but, at the same time, I will
> have to exp the database, etc... over as well. Would like to avoid that
> if AT ALL possible. Thanks for your insight.
>
> Regards,
> Al

This is much, much easier with Enterprise Manager. But if you want to do this in SQL*Plus (definitely not my recommendation), here is a link with a good example:

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14211/sql_tune.htm#i34827

Aren't the Oracle docs great?

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown