Unable to see Trace file ?

[confident]

well, recently i installed the oracle 9.2.0.6 in hpux IA64.. well i used this command to generate the trace file;

alter session set sql_trace=true;
select *****;
alter session set sql_trace=false;

i check in udump directory, there is no trace generated?
and parameter are timed_statistics=true and utl_file_dir=*
and whats problem?

[davey23uk]

you are probably looking in the wrong place

time_statistics=true is good
utl_file_dir=* is bad

[confident]

SQL> select name,value from v$parameter where name='user_dump_dest';

/APSS_ors/app/oracle/admin/STS31/udump

and permission

drwxr-xr-x 2 oracle dba 1024 Jun 9 18:41 udump

and dedicated not mts

[davey23uk]

so whats in there

[marist89]

Is it an MTS session, perhaps? If so, look in bdump.