Hi,

Am doing the following to try and generate a trc file for analysing
with TKPROF.

ALTER SESSION SET TIMED_STATISTICS=TRUE;

Then run the code i want to analyse

ALTER SESSION SET TIMED_STATISTICS=FALSE;

I check the destination of the file by the following

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

However i am not getting anything generated.

Am i missing something out?

Thanks

alter session set sql_trace = true

However without timed_statistics=true a trace file is pretty useless.

--
Sybrand Bakker
Senior Oracle DBA

what version?
there are at least 4 different methods of generating trace of a user's
session.

-bdbafh