What is TraceMagic?
TraceMagic, released in July, 2012, is a utility that developers and administrators have been waiting for for quite long. The tool was developed by the CoE using Microsoft Visual Studio 2010. It can organize complex text in your trace files into neat grids that showcases a number of performance parameters.
Where to get TraceMagic?
TraceMagic is hosted by Oracle and available for download here. You would need an Oracle support login for gaining access to the download link. After you are logged in, click the download link so that the browser prompts you to save the zip file named TraceMagic_v1.2.zip
How do I install TraceMagic?
After unzipping the file downloaded, Run the setup.exe which is inside the TraceMagic_v1.2 folder. As the tool doesn’t have a signature, Windows may prompt you for permission to install it. In half a minute, the tool is ready for use. You can launch it either from the Desktop shortcut or from Oracle Corporation > Tools & Utilities > Trace Magic. It works only on Windows machines with a .net framework.
What trace files can TraceMagic handle?
I tried loading some trace files that I already had but the tool threw an error. So it’s recommend that you activate the following tracing options when generating trace files to be used in TraceMagic.
SQL trace settings
SQL statement variables
SQL connect, disconnect, commit, rollback
All other SQL API calls except SSBs
PeopleCode trace settings
External function calls*
Internal function calls*
* these are optional
How do I use it?
Once you have installed TraceMagic and have generated the trace file as outlined in the previous step, open the tool and click Files > Open. Then select the trace file you are interested in analyzing. The tool takes a while to process the text file into easily digestible grids. I’ll soon make a tutorial on using it, stay tuned.
Finally, I managed to take a trace with the above shown settings and opened the .tracesql file in TraceMagic. The trace was for a simple login and password change. TraceMagic immediately generated the below shown charts and many tabs full of valuable information. I’m still learning to make full use of the tool though.
Where can I get support?
The tool is not yet perfect and you may face some errors while using it. Don’t worry, you can head over to this forum for help.
Can I get the source code and support?
Yes, Oracle has been kind enough to provide the source code of this tool. You can download it here. If you are a Visual Basic programmer, you may want to bring some enhancements to the tool. If you get stuck, head over to the development forum, you can get some help on the development aspects.