Generating trc file for TKPROF

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 Received on Wed May 10 2006 - 09:38:05 CDT