DBA > Job Interview Questions > DATABASE Administrator (DBA) Interview Questions and Answers

Explain the use of TKPROF? What initialization p

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Explain the use of TKPROF? What initialization parameter should be turned on to get full TKPROF output?

Level: 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.

(Continued on next question...)

Other Job Interview Questions