5 Replies Latest reply: Jul 13, 2012 3:27 PM by 929573 RSS

    alter system set events

    596722
      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
          Try: ALTER SYSTEM SET EVENTS '1555 trace name errorstack off';
          • 2. Re: alter system set events
            596722
            Thanks

            Is there any view to check if it is enabled/disabled? (Apart from alert log)
            • 3. Re: alter system set events
              ViragSharma
              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
                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
                  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