To use tracing for the Oracle JDBC driver follow these steps:

1. In the install directory, rename the original ojdbc6.dll driver to ojdbc6.dll.bak
2. Copy the debug version with the same name (ojdbc6.dll) and ojdbc6.properties into the install directory
3. Insert the following lines to Insight.exe.config before the closing </configuration> tag:

  <appSettings>
    <add key="ikvm:java.util.logging.config.file" value="ojdbc6.properties" />
    <add key="ikvm:oracle.jdbc.Trace" value="true" />
  </appSettings>

4. Insert the same lines into Administration.exe.config, Console.exe.config if tracing is needed for Administration tool or Console.
5. Start Insight.exe and a log file called ojdbc6.log will be created.

To remove the tracing:

1. Delete ojdbc.dll, ojdbc6.properties, ojdbc.log from the install directory
2. Remove the inserted xml section from the Insight.exe.config file.
3. Rename ojdbc6.dll.bak to ojdbc6.dll

Additional notes:

1. The log file will be recreated for each run of Insight.exe. To append to the existing log file change the
java.util.logging.FileHandler.append parameter in the ojdbc6.properties file to true.
2. The trace level is currently set to CONFIG. Trace level can be changed in the ojdbc6.properties file. It is not recommended to change it to FINE or ALL because it would log to much detail and bring performance down dramatically. See Oracle documentation (http://docs.oracle.com/cd/B28359_01/java.111/b31224/diagnose.htm#CIAIGACD) for more details.