Re: EVENTS

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Thu, 13 Sep 2001 09:41:14 -0400
Message-ID: <9nqd23$9e4ee$1@ID-85580.news.dfncis.de>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:a20d28ee.0109122307.7571884c_at_posting.google.com...
> "Chuck Hamilton" <chuck_hamilton_at_yahoo.com> wrote in message
news:<9nof0p$91li2$1_at_ID-85580.news.dfncis.de>...
> > Is there a syntax to set events dynamically with the ALTER SYSTEM
command? I
> > want to set the 4031 event without restarting the instance.
> >
> > --
>
> There isn't
> You can do it
> with
> - alter session set event='<event>''
> - dbms_system.set_ev(sid,serial#, event)
> - oradebug setospid <process affected> followed by oradebug event
> <text without quotes>

Looks like the dbms_system.set_ev may accomplish the same thing. Thanks for the tip.

-- Chuck Hamilton chuck_hamilton_at_yahoo.com "Do not be deceived, God is not mocked; for whatever a man sows, this he will also reap. (Gal 6:7 NASB)

application/x-pkcs7-signature attachment: smime.p7s

Received on Thu Sep 13 2001 - 08:41:14 CDT