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

Get TOAD® Handbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.