Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cannot Set Trace
you can get absolutely certain which directory by issuing the command show
parameter dest in sqlplus/svrmgrl whichever you prefer when logged on as
sysdba. look for user_dump_dest
"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 Mon Nov 26 2001 - 10:44:32 CST