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 get trace file

Re: cannot get trace file

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sat, 28 May 2005 11:07:20 +0200
Message-ID: <429834c8$0$321$ba620e4c@news.skynet.be>

"Daud" <daud11_at_hotmail.com> wrote in message news:1117270564.350587.250120_at_f14g2000cwb.googlegroups.com...
> HPUX 11i v2 (11.23)
> Oracle 9.2.0.6.0 (RAC)
>
> The problem is when we do:
>
> 1 - alter session set sql_trace=true;
> 2 - run a select statement
> 3 - alter session set sql_trace=false;
>
> we don't get a trace file produced. We checked in user dump, background
> dump directories but didn't see anything. Do you know?
>
> regards
> Daud
>

Filesystem full ? Have you done a search for *.trc files ? Looking on the correct server ? Received on Sat May 28 2005 - 04:07:20 CDT

Original text of this message

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