This discussion is archived
5 Replies Latest reply: Jul 13, 2012 1:27 PM by 929573 RSS

alter system set events

596722 Newbie
Currently Being Moderated
Hi,
i have enabled Alter system set events '1555 trace name errorstack level 3';

1) Can anyone tell me how to disable this?

2) Is there any datadictionary view to to check if this event is enabled?

Regards,
ram
  • 1. Re: alter system set events
    516450 Journeyer
    Currently Being Moderated
    Try: ALTER SYSTEM SET EVENTS '1555 trace name errorstack off';
  • 2. Re: alter system set events
    596722 Newbie
    Currently Being Moderated
    Thanks

    Is there any view to check if it is enabled/disabled? (Apart from alert log)
  • 3. Re: alter system set events
    ViragSharma Newbie
    Currently Being Moderated
    Is there any view to check if it is enabled/disabled?
    You can use dbms_system.read_ev to find out what all event currently set.
  • 4. Re: alter system set events
    Jonathan Lewis Oracle ACE Director
    Currently Being Moderated
    I don't remember a view, but if you issue:
    alter system set events 'immediate trace name events level 4';
    You will dump a trace file that shows the events set at the system level.
    (Level 2 is the process level list, level 1 is the session level list).

    Regards
    Jonathan Lewis
    http://jonathanlewis.wordpress.com
    http://www.jlcomp.demon.co.uk
  • 5. Re: alter system set events
    929573 Newbie
    Currently Being Moderated
    This is one of the good way to know whether the EVENTS has been enabled / disabled or not.

    Example:-

    1. Enabling now.

    SQL> ALTER SYSTEM SET EVENTS '10442 trace name context forever, level 10';

    2. Disabling now.

    SQL> ALTER SYSTEM SET EVENTS '10442 trace name context off';

    System altered.

    The same can be found form the alert log.

    OS Pid: 24789 executed alter system set events '10442 trace name context off'
    Sat Jul 14 04:30:25 2012

    There are ways to find out from the db level, whether this is disabled or enabled.

    one way is to use dbms_system.read_ev

    set serveroutput on

    DECLARE
    lev BINARY_INTEGER;
    BEGIN
    dbms_system.read_ev(10442, lev);
    dbms_output.put_line(lev);
    END;
    /
    10 -- means the event is enabled.

    PL/SQL procedure successfully completed.



    set serveroutput on

    DECLARE
    lev BINARY_INTEGER;
    BEGIN
    dbms_system.read_ev(10442, lev);
    dbms_output.put_line(lev);
    END;
    /
    0 -- means the event is disabled.


    The output 0 means disabled or if not set.

    Thanks,
    Partho