2. Converting Oracle Trace Files

2. Converting Oracle Trace Files

It is important to note that to convert Oracle trace files you must have selected Oracle from the treeview. If another database is selected the button to convert Oracle trace files is disabled Copy the trace file to the client machine or location where HammerDB is running and use the File:Open menu option or the “Open an existing file button” under the Edit Menu to display the Open File dialogue

Figure 13.2. Open File

Open File

The Open File dialog allows the specifying of the Directory and a filter for the file type, by default this is *.tcl. Change the file extension to ‘trc’ and change directory to the location of your files, select the trace file you previously generated and select OK.

Figure 13.3. Trace Loaded

Trace Loaded

Select the Trace Conversion button at the bottom of the Edit menu

Figure 13.4. Convert Trace

Convert Trace

and the trace file is converted into a format that can replayed against the database.

Figure 13.5. Trace Converted

Trace Converted

Note that the trace file never records a users’ authentication details. Therefore the connect string must always be modified manually after conversion. Remove the comment before the “set connect” line on line 4 and enter the correct username and password. The SID will be set by default to the SID that the trace file was taken from and therefore if using a pluggable database then the correct container must also be set to the correct identifier. Once the connect string is updated the generated script is ready for running against the database and contains the original statements that were traced. The save menu option or “Save current file” button can be used to save the generated script for reloading at a later point in time.