Toad and TKProf
TKProf is the command-line interpreter for the Oracle RDBMS for SQL Trace files. It can be a bit difficult to use, but Toad makes it very easy with the TKProf wizard. Access this from Database → Diagnose → TKProf Wizard. The Files button (see Figure 10.15) enables you to access trace files from your workstation or by using FTP.
FIGURE 10.15 Toad TKProf wizard
Tip
Dan always gets these trace files to his workstation, and then opens them by clicking the Files button and selecting Browse Windows Files.
Fill out the sort grid as shown in Figure 10.16 (some knowledge of trace files is helpful) and Toad will then run the TKProf ...
Get Toad for Oracle Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
