Re: sql_text during parsing
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Mon, 12 Jul 2021 19:40:15 +0300
Message-ID: <CAOVevU6hzCzC039B=Ww7pujjXoOqPmH9RUtTgRgq7Oza-OaCcw_at_mail.gmail.com>
Date: Mon, 12 Jul 2021 19:40:15 +0300
Message-ID: <CAOVevU6hzCzC039B=Ww7pujjXoOqPmH9RUtTgRgq7Oza-OaCcw_at_mail.gmail.com>
Hi Nenad,
Since you already have an SQL_ID of your query, probably it would be better
to enable 10053 on this sql_id?
alter system set events 'trace[SQL_Compiler.* | SQL_Execution.*][SQL:
99g4t6h9kfumw]';
On Mon, Jul 12, 2021 at 7:35 PM Noveljic Nenad <nenad.noveljic_at_vontobel.com> wrote:
> Hi Sayan,
>
>
>
> Yes, I tried it, but unfortunately, nothing was there.
>
>
>
> Best regards,
>
>
>
> Nenad
>
>
>
-- Best regards, Sayan Malakshinov Oracle performance tuning engineer Oracle ACE Associate http://orasql.org -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 12 2021 - 18:40:15 CEST