Re: tracing specific sql_id in 12.2
From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Thu, 14 Dec 2017 18:14:40 +0200
Message-ID: <CAMHX9J+89O74Fd82cVxnN04s6oiWK59AROT4dX+RYnkU2HPNGg_at_mail.gmail.com>
Date: Thu, 14 Dec 2017 18:14:40 +0200
Message-ID: <CAMHX9J+89O74Fd82cVxnN04s6oiWK59AROT4dX+RYnkU2HPNGg_at_mail.gmail.com>
Maybe there's some bug in 12.2 with event propagation when using ALTER SYSTEM, maybe a variation of what's described here:
... Although eventdump seems to show the event is enabled for the session too. Did you start session 2 before or after issuing ALTER SYSTEM in st?
If 12.2 happens to use the Multitenant config, perhaps test running the ALTER SYSTEM at the root CDB level...
-- Tanel Poder http://blog.tanelpoder.com On Tue, Dec 12, 2017 at 5:02 PM, Noveljic Nenad <nenad.noveljic_at_vontobel.comReceived on Thu Dec 14 2017 - 17:14:40 CET
> wrote:
> Has somebody tried tracing a specific sql_id in Oracle 12.2? The feature
> doesn’t seem to work properly.
>
>
>
> Here’s the test case:
>
>
>
> Session 1:
>
> alter system set events='sql_trace[sql: 2asugy1n1r7y7] level=12' ;
>
> SQL> alter system set events='sql_trace[sql: 2asugy1n1r7y7] level=12' ;
>
>
>
> System altered.
>
>
>
>
>
-- http://www.freelists.org/webpage/oracle-l