Re: SQL performance in prod
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Wed, 18 Jul 2018 23:46:58 -0400
Message-ID: <CAOVevU7WD3Y-X6f-tYoHPBXGO60bphCPw+9LaecFkBkbw4kwsA_at_mail.gmail.com>
Date: Wed, 18 Jul 2018 23:46:58 -0400
Message-ID: <CAOVevU7WD3Y-X6f-tYoHPBXGO60bphCPw+9LaecFkBkbw4kwsA_at_mail.gmail.com>
Raman,
You can enable 10053 for this sql only and just wait when it repeat bad
plan:
alter system set events 'trace[rdbms.SQL_Optimizer.*][sql:your-sql_id]';
ср, 18 июл. 2018 г., 23:34 V Raman <vraman4list_at_gmail.com>:
> but I will keep 10053 in mind. thanks
>
> On Wed, Jul 18, 2018 at 10:33 PM, V Raman <vraman4list_at_gmail.com> wrote:
>
>> Thanks Sayan. I can get the 10053 for the good one. We dont know when
>> the bad plan will hit us next.
>>
>> On Wed, Jul 18, 2018 at 10:30 PM, Sayan Malakshinov <xt.and.r_at_gmail.com>
>> wrote:
>>
>>> Hi Raman,
>>>
>>> The easiest way is to get and compare 10053 traces for both plans.
>>>
>>>
>>>>>
>>>>
>>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 19 2018 - 05:46:58 CEST