Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Cannot Set Trace

Re: Cannot Set Trace

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 26 Nov 2001 16:44:32 -0000
Message-ID: <9ttrhg$4d0$1@plutonium.btinternet.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US