Re: tuning advisor ... again

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Fri, 4 Aug 2006 21:41:01 GMT
Message-ID: <J3HtKG.3L4@igsrsparc2.er.usgs.gov>

Akimeu wrote:

> 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

> Thanks guys... that manual way really does look like a pain!  Is there 
> anyway to export the findings from the database in question, import them 
> into an em database and run the tuning advisor that way?  The problem is 
> that I cannot connect to the problem database except through sqlplus and 
> exp.  Thanks again.
> 
> Al

Why not take a dump of your schema and import into a database that you can use EM with? The ADDM report will show you the trouble SQL. You can then create a SQL Tuning Set with that SQL statement(s). From there, you can use EM on this new db to run the SQL Tuning Advisor.

HTH,
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

Received on Fri Aug 04 2006 - 16:41:01 CDT