Re: set events: control the number of sessions that dump trace

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 20 Aug 2019 14:42:35 -0700
Message-ID: <CAORjz=OdnGhsdwAReGUwVkxXg=hJn25xR02izVmnGMNmp+-8vw_at_mail.gmail.com>



Used this command:

  alter system set events '1555 incident(forceora1555)';

Nothing generated by an ORA-1555, not even a mention in the alert log.

I found the following note to be an excellent reference:

Monitoring 11g Database Alert Log Errors in Enterprise Manager 10g and 11g Grid Control (Doc ID 949858.1)

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/ Github: https://github.com/jkstill

On Tue, Aug 20, 2019 at 2:05 PM Jared Still <jkstill_at_gmail.com> wrote:

> On Tue, Aug 20, 2019 at 1:56 PM Mikhail Velikikh <mvelikikh_at_gmail.com>
> wrote:
>
>> It looks like you have not fired any incidents. The key thing in my
>> message was that incident keyword in the event syntax:
>> alter system set events '1555 *incident*(sto)';
>>
>>
> I did not realize that was literal syntax you were referring to. I will
> give it another try.
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 20 2019 - 23:42:35 CEST

Original text of this message