What is tkprof and how is it used?
By admin on Mar 8, 2007 in SQL/ SQLPlus interview questions
Level: Intermediate to high Expected answer: The tkprof tool is a tuning tool used to determine cpu and execution times for SQL statements. You use it by first setting timed_statistics to true in the initialization file and then turning on tracing for either the entire database via the sql_trace parameter or for the session using the ALTER SESSION command. Once the trace file is generated you run the tkprof tool against the trace file and then look at the output from the tkprof tool. This can also be used to generate explain plan output.
2 Comment(s)
By madhu on Mar 22, 2008 | Reply
what is hot backup?what will happened if we will put in begin backup mode?will it write the data to datafiles if it is in begin backup mode?
By madhu on Mar 22, 2008 | Reply
will index be created if we will create primary key on particular column?