Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Event 10046
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