Re: showing set events

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 29 Nov 2007 15:11:44 -0800
Message-ID: <1196377897.385025@bubbleator.drizzle.com>

sybrandb_at_hccnet.nl wrote:

> On Thu, 29 Nov 2007 09:06:50 -0800 (PST), "oracle_man_at_yahoo.com"
> <rheadrick_at_dbspecialists.com> wrote:
> 

>> Anyone know how to tell if an event is currently set such as "ALTER
>> SYSTEM SET EVENTS '1652 trace name errorstack';" ?
>>
>> Show parameter does not tell me.
>>
>> Daniel, it was good to see you at NOCOUG. Sorry I didn't get a chance
>> to say hi.
>>
>> --Rich

>
> use dbms_system.read_ev

Interestingly enough I can not get this to work in 11gR1.

A few more minutes and ....

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Nov 29 2007 - 17:11:44 CST