cannot get trace file

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 Received on Sat May 28 2005 - 03:56:04 CDT