PeopleSoft practices will showcase entire knowledge value and tips to use and configure PeopleSoft ERP – sharing knowledge from experienced consultants and ERP experts
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 designed primarily to address the difficulty in working with tracesql files when attempting to determine which SQL statement(s), and or PeopleCode programs are causing performance problems. As such, it tends to assume that certain trace flags were set during the creation of the trace file.
Peoplesoft Practices
135 members
Description
PeopleSoft practices will showcase entire knowledge value and tips to use and configure PeopleSoft ERP – sharing knowledge from experienced consultants and ERP experts
TraceMagic: Utility for analyzing *.tracesql trace files
by Major Tooley
Dec 13, 2013
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.
determine which SQL statement(s), and or PeopleCode programs are causing performance problems. As such, it tends to assume that certain trace flags were set during the creation of the trace file.