RE: How to find events that are currently set in an instance

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Fri, 9 Jun 2006 13:07:17 -0400
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF4105079577BE@usahm236.amer.corp.eds.com>

 

This script looks like one Steve Adams published on his web site years ago. It is for finding trace events set in the current SESSION not for the instance.

You use oradebug to dump the events set at the system level or in a specific session.

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mindaugas Navickas Sent: Friday, June 09, 2006 12:32 PM
To: Amir.Hameed_at_xerox.com; oracle-l_at_freelists.org Subject: Re: How to find events that are currently set in an instance

Hi Amir,

This is the way to find it.

SET SERVEROUTPUT ON
DECLARE
 l_level NUMBER;
BEGIN
  FOR l_event IN 10000..10999 LOOP

          dbms_system.read_ev (l_event,l_level);     IF (l_level > 0) THEN

      dbms_output.put_line ('Event '||TO_CHAR (l_event) ||
      			' is set at level '||TO_CHAR (l_level));

    END IF;
  END LOOP;
END;
/

Regards
Mindaugas Navickas

PS I am not author of this script and I do not know whom to credit for it.

• "Hameed, Amir" <Amir.Hameed_at_xerox.com> wrote:

> Hi Folks,
> Is there a way to find out all the events that are currently set in an

> instance?
>
> Thanks
> Amir
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

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


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

Received on Fri Jun 09 2006 - 12:07:17 CDT