Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Event 10046

Re: Event 10046

From: Anjo Kolk <k.kolk_at_chello.nl>
Date: Wed, 09 May 2001 16:49:52 GMT
Message-ID: <3AF97612.65BC0D0B@chello.nl>

dbms_system.set_ev(<sid>,<serial#>,10046, <level>,null);

Will also do it and you don't need oradebug.

Sybrand Bakker wrote:

> "Ivan Bajon" <bajon_at_nospam@worldonline.dk> wrote in message
> news:9db2dk$9dl$1_at_news.inet.tele.dk...
> > Hi folks
> >
> > Could someone please tell me how to enable event 10046 for another session
> > than "my own"?
> >
> > Regards,
> > Ivan Bajon
> >
> >
>
> You need to run svrmgrl
> then
> oradebug set ospid <the spid of v$process for the affected session
> oradebug set event '10046 trace name context forever, level 12'
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
  Received on Wed May 09 2001 - 11:49:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US