How to use "lifetime" clause to limit the number of traces correctly
From: kunwar singh <krishsingh.111_at_gmail.com>
Date: Tue, 19 Nov 2019 08:52:50 -0500
Message-ID: <CAJSrDUrtwUYBsRgkAVpEww_xaa=KQjrvPvzAxKkiHscYLS0LRA_at_mail.gmail.com>
Hi Listers,
I am reading this link:
https://blog.tanelpoder.com/2009/03/03/the-full-power-of-oracles-diagnostic-events-part-1-syntax-for-ksd-debug-event-handling/
Date: Tue, 19 Nov 2019 08:52:50 -0500
Message-ID: <CAJSrDUrtwUYBsRgkAVpEww_xaa=KQjrvPvzAxKkiHscYLS0LRA_at_mail.gmail.com>
Hi Listers,
I am reading this link:
https://blog.tanelpoder.com/2009/03/03/the-full-power-of-oracles-diagnostic-events-part-1-syntax-for-ksd-debug-event-handling/
then i tried to test the tracing using the below example.
alter system set events '942 trace name errorstack level 3,*lifetime *2';
but it keeps dumping error stack even after 2nd incident of the error.
Is something broken/wrong with my syntax or tracing level or do i have use
some alternative syntax.
I am trying this in 12.2.0.1 .
The reason i am playing with it is to troubleshoot issue in an 11.2.0.4 for a different ORA error thrown by the application.
--
Cheers,
Kunwar
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 19 2019 - 14:52:50 CET