Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Advanced SQL_TRACE
SQL> alter session set events '10046 trace name context off';
Session altered.
Martin
Stephan Bressler wrote:
>
> Hi,
>
> how about switching it off?
> alter session set events '10046 trace name context forever, level 0';
> returns an error (ORA-02194: event specification syntax error 231 (minor
> error 283) near '0')
>
> TIA
> Stephan
>
> "Steve Ashmore" <sashmore_at_neonramp.com> wrote in message
> news:ues673iv4d78ac_at_corp.supernews.com...
> > To show Waits and binds:
> >
> > At the system level
> >
> > alter system set events '10046 trace name context forever, level 12';
> >
> > or at the session level
> >
> > alter session set events '10046 trace name context forever, level 12';
Received on Thu Jun 13 2002 - 06:28:40 CDT
![]() |
![]() |