Re: Event 10046

Try '' instead of NULL.

make sure that the sid and serial# match (check v$session).

Anjo.

Ivan Bajon wrote:

> Anjo,
>
> I tried this prior to my post with name = "context forever" which didn't
> work. After your reply I tried using null. Still no trace. Wonder what I'm
> missing.
>
> Regards,
> Ivan
>
> "Anjo Kolk" <k.kolk_at_chello.nl> wrote in message
> news:3AF97612.65BC0D0B_at_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 Thu May 10 2001 - 03:59:27 CDT