TraceMagic is a utility that gives PeopleSoft system administrators, programmers and support engineers the ability to quickly isolate performance bottlenecks in SQL Statements and/or PeopleCode functions. It accomplishes this by turning the text-based, time-ordered tracesql file into a sortable-grid display, allowing the user to quickly locate system performance issues.
TraceMagic is a great tool for reading
.tracesql files. The ability to group SQL by SELECT statements and see all the tables queried in the trace are great for debugging issues.