SQL (Structured Query Language) Question:
What is tkprof and how is it used?
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.
| Previous Question | Next Question |
| What is the default ordering of an ORDER BY clause in a SELECT statement? | What is explain plan and how is it used? |