Trace Collier Utility – Updated

   Send article as PDF   

Trace CollierĀ has been updated after a couple of foibles were found during the processing of a trace file.

The version has been bumped to 0.19 as of today, 2nd December 2016. The bugs fixed were:

  • The utility now notices exec ERROR lines as well as PARSE ERRORs. Just because it’s nice to know where things might have gone wrong. These are in addition to the PARSE ERRORs that it has been processing up until now.
  • Interesting bug, seemingly related to DBMS_METADATA.GET_CLOB calls where the value for one bind is the bind number of the next one. The text in the trace file is “value= Bind#” and is weird! It should be on two lines, everything after the equals sign, including the space, should be on the next line. Detected on Windows 11204 and on Solaris 11204.
  • Sort of fixed the problem where a bind can be used more than once in a statement. Flagged in the SQL as “__A_:BIND_REUSED__” at the moment. This will be properly fixed in future but where the same bind variable is used more than once in a statement, the code now (sort of) handles it correctly. An issue has been raised on GitHub for this.
  • Added test.cmd. Test harness for Windows users.

You can read more about Trace Collier here if you wish.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.