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: Ivan Bajon <bajon_at_nospam@worldonline.dk>
Date: Thu, 10 May 2001 09:21:31 +0200
Message-ID: <9ddfhn$t8b$1@news.inet.tele.dk>

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 - 02:21:31 CDT

Original text of this message

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