Re: Cannot Set Trace

hello,

you could try also

exec sys.dbms_system.set_sql_trace_in_session(<SID>,<SERIAL#>,true);

from another session
where sid and serial are derived from v$session.

true turns tracing on,
false ... off.

maybe this helps

bye

stefan k.

"Buck Turgidson" <jc_va_at_hotmail.com> wrote in message news:<ayAL7.35954$fm5.4937811_at_typhoon.southeast.rr.com>...
> I am trying to trace a session and it's bind variables on 8.1.6 on
> Linux.
>
> As sys, I "exec dbms_system.set_ev(8,37,10046,4,'')". I then go to
> the udump directory, but it is empty. I am sure that the session in
> question has had activity. I have also tried "ALTER SESSION Set
> SQL_TRACE = TRUE" from within the session I want to trace, with no
> luck.
>
> I am fairly certain that I am looking in the correct directory because
> a sister directory, arch, contains archived logs.
>
> Any suggestions on what to try next?
Received on Sat Nov 24 2001 - 11:48:58 CST