Re: tracing specific sql_id in 12.2
From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Fri, 15 Dec 2017 00:03:06 +0200
Message-ID: <CAMHX9J+DAVYV7LT2XHjbrnc0N5diFrm3_TX8XQq1cFUkZ6MGHg_at_mail.gmail.com>
Date: Fri, 15 Dec 2017 00:03:06 +0200
Message-ID: <CAMHX9J+DAVYV7LT2XHjbrnc0N5diFrm3_TX8XQq1cFUkZ6MGHg_at_mail.gmail.com>
You've been having fun :-)
I geeked out a bit and tested this out too on 12.2 ... indeed, seeing the same behavior. Also interesting that when using ALTER SYSTEM to disable that event, it doesn't remove it from the other session (as far as eventdump shows)... so it's telling that even the ALTER command/event propagation doesn't seem to recognize this event being set (correctly) in these secondary sessions.
-- Tanel Poder http://blog.tanelpoder.com On Thu, Dec 14, 2017 at 6:48 PM, Noveljic Nenad <nenad.noveljic_at_vontobel.comReceived on Thu Dec 14 2017 - 23:03:06 CET
> wrote:
> No multitenant, and tested with both new and existing 2. session. Most
> probably a bug - quite inconvenient.
>
>
>
> However, I’ve managed to reconstruct the doubly linked list, where the
> system events are stored:
>
>
>
> linked list ptr to root entry:
>
> BCFFDE18+28: *BCFFDE40 = 989423B8
>
>
>
> root_Entry:
>
> 989423B8+ 0: *989423B8 = 00000080
>
> 989423B8+B8: *98942470 = 96DDD200
>
>
>
>
>
-- http://www.freelists.org/webpage/oracle-l