Re: tracing ORA-00932

Yep with ALTER SYSTEM you're really setting this event for every session, so it's enabled in all sessions and every session will have its own independent lifetime counter.

This may also be intereting/relevant when setting events with ALTER SYSTEM (10g & 11g behave differently):

http://blog.tanelpoder.com/2013/10/07/why-doesnt-alter-system-set-events-set-the-events-or-tracing-immediately/

Tanel.

On Sat, Sep 30, 2017 at 10:27 AM, GG <grzegorzof_at_interia.pl> wrote:

> indeed I was able to get what I want via:
>
> ALTER system SET events '932 trace name errorstack level 3, lifetime 1';
> ALTER system SET events '932 trace name context off';
>
> one little oddity I noticed was liftime 1 related to session so only one
> trace per session not per system .
> I was expecting the trace to stop after getting one occurence at all .
> That my impression at least .
> Regards .
> G
>

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