Toad and Trace File Browser
The Toad DBA Pack has a unique tool for interpreting the results of SQL Trace files: the Trace File Browser. This interface is just under the TKProf wizard on the Database → Diagnose → Trace File Browser menu. Figure 10.19 shows the Trace File Browser with the same SQL Trace file opened (using the Open File button) as in the previous section on the TKProf wizard.
FIGURE 10.19 Toad Trace File Browser
Notice that this wizard enables you to sort by simply clicking on the report headings. This browser makes it possible for the SQL within the SQL Trace file to be quickly analyzed.
Tip
Dan first finds the longest running ...
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.
