This week on the podcast, Dan shares an open source project to manage your Oracle Database grant permissions from the PIA. Kyle gives Dan some tips on using SSH aliases, and Dan shares how to trace FTP transactions with PeopleSoft.
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.