Re: EVENTS

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 13 Sep 2001 00:07:16 -0700
Message-ID: <a20d28ee.0109122307.7571884c@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>

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Thu Sep 13 2001 - 02:07:16 CDT