I’ve been trying to find a way to post an executable for several weeks because I’ve been sent a simple viewer for 10053 trace files written by Hans-Peter Sloot of Atos Origin and Robert van der Ende. They wrote this viewer because trace files from event 10053 can be enormous, and scrolling back and fore through them to cross reference the interesting bits can be extremely tedious. Their “tree-viewer” allows you to see all the important headings and expand only the detail you’re interested in.
It works very simply: start the program from a command line, wait for the graphic interface to pop up and click on “Open trace file” to get a standard “File Open” menu from windows. After opening your selected file you get a drop-down list of registered queries in that file; scroll down to one of them and click on “Show trace file”. From that point on you can click on the “+” and “-” signs that appear in the text, or make use of the right (+) and left (-) arrows to expand and contract text.
The following is a screen snapshot (which may look very messy on smaller screens) of the tool in action:
If you want to download the viewer, I’ve been able to post it the Oak Table Network site but had to do something a little strange with it. I’ve saved it on the site with a “.doc” suffix, so it appears to WordPress to be a Word document. To download it and use it you have to do the following:
Right click on this link and choose the option to “save target as”
The default filename to save will be new_treeview.zip.doc
Edit the filename to remove the .doc suffix and then save the file
You now have a zip file that should unzip correctly.
I have tested the download from this page and it does seem to be working properly.
Note: this is a viewer for trace files from Oracle 10g – it’s not supposed to work with earlier versions.
Update Dec 2011:
Hans-Peter sent me an updated file over a year ago – fixing some bugs in the earlier version – and I’ve only just got around to uploading it. It’s using the same odd naming tricks as the original, but I have managed to load it on to my own blog this time around. If you download this version you’ll get a file called tvzip1.doc on your system; change the file extension from .doc to .zip and you will be able to extract from it a file called tv10053.xxx; change the extension to .exe and you have the executable (DOS/Windows only).