Re: tracing specific sql_id in 12.2

This is bug 25989066 (and 25994378), fixed in 18.1, no backport to 12.2 available yet.

rgds

On Thu, Dec 14, 2017 at 11:14 PM, Noveljic Nenad < nenad.noveljic_at_vontobel.com> wrote:

> You've been having fun :-)
>
> ð Indeed: no bugs – less fun J !
>
>
>
> 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.
>
> ð Are you also getting an ORA-0600 or ORA-07445 in some dbgd clean-up
> function? This would actually confirm a mess-up with the pointers in the
> linked list.
>
>
>
> Thanks for looking at the problem!
>
>
>
> Nenad
>
>
>
> --
>
> Tanel Poder
>
> http://blog.tanelpoder.com
>
>
>
> On Thu, Dec 14, 2017 at 6:48 PM, Noveljic Nenad <
> nenad.noveljic_at_vontobel.com> 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
>
>
>
>
>
> ____________________________________________________
>
> Please consider the environment before printing this e-mail.
>
> Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
>
>
> Important Notice
> This message is intended only for the individual named. It may contain
> confidential or privileged information. If you are not the named addressee
> you should in particular not disseminate, distribute, modify or copy this
> e-mail. Please notify the sender immediately by e-mail, if you have
> received this message by mistake and delete it from your system.
> E-mail transmission may not be secure or error-free as information could
> be intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also
> processing of incoming e-mails cannot be guaranteed. All liability of the
> Vontobel Group and its affiliates for any damages resulting from e-mail use
> is excluded. You are advised that urgent and time sensitive messages should
> not be sent by e-mail and if verification is required please request a
> printed version.
>

--
http://www.freelists.org/webpage/oracle-l