Tracing Execution Using TKPROF
In the old days before Oracle debuggers and profilers became available, the only way to see what was going on inside your program was the TKPROF utility. This was an undocumented tool first available in Oracle version 5. But then Oracle support began having people utilize it to troubleshoot their problems, so Oracle made it an official utility in Oracle version 6. And although today’s debugger and profilers are snazzy, TKPROF still offers some value during application development. So TOAD offers the TKProf Interface. However, there are some preparatory steps you must perform in order to effectively utilize this utility.
Capturing Trace Output to Profile
First, you must start the trace for the session you want ...