TKPROF

[badrinathn]

Hi
I have 2 simple questions:

1) How do I give my own name to the .trc files when I set SQL_TRACE = TRUE.

2) Which environment parameter should I set for seeing the actual time elapsed of a particular
operation in the trace file(after running tkprof). I feel it is something like
alter session set time_statistice =true (Not confident, also this does not work)

Badrinath

[gpsingh]

Cannot change the name for the files.
timed_Statistics=true

[sambavan]

I would also suggest you to take a look into oracle metalink site. They have a number of v.usefull docs on SQL trace

Good luck,
Sam