Skip to Main Content
Toad for Oracle Unleashed
book

Toad for Oracle Unleashed

by Bert Scalzo, Dan Hotka
July 2015
Intermediate to advanced content levelIntermediate to advanced
288 pages
7h 26m
English
Sams
Content preview from Toad for Oracle Unleashed

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.

Image

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Toad for Oracle

Toad for Oracle

Dan Hotka
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern
Oracle in a Nutshell

Oracle in a Nutshell

Rick Greenwald, David C. Kreines

Publisher Resources

ISBN: 9780134131900Purchase book