Re: Turn tracing on for a session

"Marc Eggenberger" <marc.eggenberger_at_itc.alstom.com> wrote in message news:MPG.19b52650e586840a9896ce_at_iww.cacti.ch.alstom.com...
> In article <3F4A37F9.BFB5BA3E_at_exxesolutions.com>,
> damorgan_at_exxesolutions.com says...
>
> [...]
>
> > Try logging on to the session and issuing:
> >
> > ALTER SESSION SET EVENTS '10046 trace name context forever, level 12';
>
> Can this be done outside of the session. Because the application is a
> third party software where I cannot issue sql commands directly ... only
> GUI.
>
>
> --
> mfg
> Marc Eggenberger

Yes, using dbms_system.set_ev (need to have the sid and the serial# first of course
or using oradebug in sqlplus
oradebug set ospid <spid of the affected session> oradebug unlimit
oradebug event 10046 trace name context forever, level 12

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address