Can you explain the use of TKPROF and the initialization parameter which needs to be used to get full TKPROF output?

When responding to this question, the first thing you should do is define tkprof. This will demonstrate your knowledge of the process and confirm that this is what the interviewer is asking you about. The next step is to discuss what this command does and the results you obtain by using the final part of the answer to describe the initialization parameter you would use to get the full output. Answering the question in this manner will ensure that you provided the interviewer with all the information they were expecting.

"The tkprof tool is a tuning tool used to determine the CPU execution times for SQL statements. To use the tool, you start by setting the timed statistics parameter to 'true' in the initialization file. The next step is to turn on tracing. You can do this for the entire database by utilizing the SQL trace parameter or for just the current session using the ALTER SESSION command. Either of these will generate the trace file. Once this is complete, you can run the tkprof tool against the trace file and examine the output."