Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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
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 Received on Fri Aug 04 2006 - 12:34:12 CDT