Re: 10.2 SQL Profile
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Fri, 26 Jan 2018 08:56:50 +0300
Message-ID: <CAOVevU6HeHC_9y-GOV_sQFkRuKgVZ-b1hRRQQvcpv1tkXehQwA_at_mail.gmail.com>
Date: Fri, 26 Jan 2018 08:56:50 +0300
Message-ID: <CAOVevU6HeHC_9y-GOV_sQFkRuKgVZ-b1hRRQQvcpv1tkXehQwA_at_mail.gmail.com>
Hi Hemant,
Sometimes it's much easier and more reliable to create profiles with hints
from real outline of your desirable plan (wihtout
OPT_ESTIMATE(...scale_rows)).
And after sql profile creation I check it using this script:
https://github.com/xtender/xt_scripts/blob/master/profiles/test_xplan_by_sqlid.sql
On Fri, Jan 26, 2018 at 5:39 AM, Hemant K Chitale <hemantkchitale_at_gmail.com> wrote:
> This is 10.2.0.5 (sorry, not 10.2.0.4 that I reported).
> I used DBMS_SQLTUNE procedures -- see my email to Andrew Kerber.
>
>
> Hemant K Chitale
>
-- Best regards, Sayan Malakshinov Oracle performance tuning engineer Oracle ACE Associate http://orasql.org -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 26 2018 - 06:56:50 CET