When running Toad's TKProf wizard, the log results display error messages, and it also shows an unsuccessful execution.
Here's an example of a failed execution in the TKProf Wizard:
UNKNOWN SESSION ID
0 statements EXPLAINed in this session.
********************************************************************************
Trace file: C:\Data\TOAD\OAPD_0802.mgr
Trace file compatibility: 9.00.01
Sort options: default
0 session in tracefile.
0 user SQL statements in trace file.
0 internal SQL statements in trace file.
0 SQL statements in trace file.
0 unique SQL statements in trace file.
4712 lines in trace file.
Toad's TKProf Wizard relies on Oracle's tkprof.exe application so Toad's wizard will produce the exact same output as Oracle's tkprof.exe application.
The TKProf Wizard runs an application called tkprof.exe that is located in the Oracle bin client directory. Normally the tkprof.exe application is executed on the command line, but Toad provides a user friendly wizard interface to execute the tkprof.exe application.
To test whether or not Toad's TKProf Wizard provides the same output as Oracle's tkprof application, please do the following:
1) In Toad, go to View | Options | Executables. On the right, you should be able to review the path of your tkprof.exe application.
2) Now go to Tools | TkProf Interface to launch the TKProf Wizard. Select and input all of the desired options.
3) When you reach the last TkProf Wizard screen, select "Just copy the command(s) to the clipboard" and click Finish.
4) Now open a new Notepad file and paste the information. The command should look similar to this:
tkprof D:\oracle\admin\VDo92\udump\vdo92_j001_3444.trc D:\oracle\admin\VDo92\udump\vdo92_j001_3444.OUT aggregate=NO SYS=NO
5) Open a command prompt window by going to Start | Run | type "cmd" and press Enter.
6) In the command line, cd to the path of the tkprof.exe application and paste the tkprof command that you copied earlier in the Notepad file, then press Enter to execute.
7) Once the command has been executed, go to the directory where the .OUT file was created to and verify if you get the same output that you get in Toad's TKProf Wizard.
If Toad's TkProf wizard results is different than Oracle's TkProf result, please submit a service request with Quest Support Portal at https://support.quest.com/CaseManagement/ManageServiceRequest.aspx
