TKPROF Utility... Utilization.

[Oracledba8]

Hi Guys,

Can any one please elaborate the quick and easy method of using TKPROF Utility.

I don't know much about this but I know that I have to issue Alter Session set SQL_Trace = True, But how to do that on database level and where will I see that Trace and How to use that...

Please explain me in Details... Step by Step.
Any help greatly appreciated.
Thanks...

[jmodic]

To enable tracing on instance level you have to set the init parameter SQL_TRACE=TRUE and restart the database (I'm not sure, maybe in new releases this parameter can be set dynamically, without bouncing the database).

Once this parameter is set each session will begin to write its own trace file in your USER_DUMP_DESTINATION directory. You can then analyze each of those trace files with TKPROF individually, or you can concatenate them into one large file and run TKPROF on it.

Oracle Tuning manual will give you more details....

HTH,

[Oracledba8]

Thanks Jmodic,

How would I use that SQL Tracing with TKPROF... That's what I need to know.

Can you please elaborate more. Anyother feedback also appreciated.

Thanks.

[Sharma]

SQL_TRACE=TRUE will start generating the output in Trace file in user dump. TKPROF is a OS utility and will convert the output in a readable format. You can go through the the report (Text file) generated by TKPROF.