SQL & PL/SQL

Hi All,

I am tracing the sql query by using SQL Trace and TKPROF.

I am setting up the initial parameter as follows.

alter session set SQL_Trace=true;

Session altered.

alter session set TIMED_STATISTICS=true;

Session altered.

alter system set USER_DUMP_DEST='d:\dump';

System switch log altered.

after this initial set up. i am running the sample query such as

select sysdate from dual;

SYSDATE  
---------
11-OCT-10

1 row selected.

alter session set SQL_Trace=false;

Session altered.

after executing the above command. i have searched for xxxx.trc file in directory but i can't able to find the file.. what is wrong i did.. why i can't able to view the file in directory... any suggestion?

Thanks and Regards
Sami.