TraceMagic – The Tool to Analyze PeopleSoft Trace Files

PeopleSoft TraceMagic

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.

About TraceMagic Tool

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 statements
SQL statement variables
SQL connect, disconnect, commit, rollback
SQL fetch
All other SQL API calls except SSBs

PeopleCode trace settings
Program starts
External function calls*
Internal function calls*

* these are optional

Trace Settings for TraceMagic

Trace Settings for TraceMagic

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.

TraceMagic Tool - Main Screen

TraceMagic Tool - Main Screen

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.

TraceMagic Graphs

Summary Graphs in TraceMagic

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.

Tags: , ,
Subscribe to Comments RSS Feed in this post
11 Responses
  1. It is not possible to download this from oracle site, can you give any alternate download link? Maybe you can upload your copy to dropbox public folder.

    • I just tried using the original link mentioned in this post and it doesn’t seem to work anymore. Thanks for pointing this out.

      Meanwhile, I was able to find this alternate link. Can you try using it?
      Trace Magic download

      Have edited the link in the post.

  2. I can’t download from this link.
    Can you give another download link ?
    Thank you

  3. error download :
    The attachment is not reachable or server error ..

    Help please

    • Roger, I just tried the download link and it’s working for me.
      It first takes you to the login page and once you login, starts downloading.

      Not sure why you are facing an issue. What browser are you using?

  4. Hi,
    I’m the author of TraceMagic – I wanted to thank you for your post – and to make you aware there is a new version of the tool – much more stable, and that has tons of enhancements – including the ability to compare 2 trace files (very useful when you want to compare demo to prod and such)… please visit the forum should you have issues or questions… and thanks again!
    Graham

    • @Graham,

      Thanks for dropping by and let us know about the new version with enhanced features. I will shortly give it a try!

Pingbacks/Trackbacks
Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

*

Recommended for you:
Field Level vs Record Level Auditing
Record Level Audit vs Field Level Audit

Close