| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Advanced SQL_TRACE
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 Wed May 29 2002 - 04:20:07 CDT
 |
 |