TOAD will run the Oracle trace function for you, run TKPROF and display the important information in the Auto Trace tab of the results panel; see Figure 3.45. Figure 3.45. TOAD Auto Trace tab.
If the Auto Trace feature is not turned on for your login session, TOAD will tell you that it is disabled and ask you if you want it enabled. It is beyond the scope of this book to discuss all the various fields in this tab's output, but here are several of the most important fields:
It is beyond the scope of this book to go into great depth as to the meaning and interpretation of these various statistics. The user running Auto Trace will need access to the V$STATNAME and V$SESSTAT dictionary views as illustrated in Figure 3.46. Figure 3.46. TOAD Auto Trace required permissions.
|