Daud wrote:
> 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
Given that this is RAC ... how are you determining which instance had
the session? The instance with the session determines the server. Then
follow the init parameter to the file.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sat May 28 2005 - 09:42:36 CDT
