Oracle Trace File Browsers?

Question

Can anyone recommend a graphical tool to make browsing Oracle SQL Trace files easier?

TKProf is great for summary info, but lately I am needing more detail on a specific run of a statement and end up going back to the trace file directly. Summarization and filtering would be pluses, but mainly looking for something with some basic drill down into detail for each statement.

I stumbled upon the trace file browser in SQL Developer 1.5.5. It would be perfect if it didn't take minutes to load up multi-megabyte files.

I have Toad 9.x but I can't seem to invoke the utilities for viewing trace files, possible I don't have that option licensed. Like so many features I find hints about it in the online help but can't seem to find the menu selections they mention in the help file or a clear connection to what needs to be licensed to enable the feature.

Do you have any suggestions for any other tools I should investigate?

Answer 1

Allround Automations' PL/SQL Developer has a GUI for viewing traces. I've only used it for small traces myself but it seems pretty quick.

There is a trial version available for download from their website, I would recommended trying it out and seeing how it works for you. My company has bought us licenses and frankly, if you are developing PL/SQL, this is the best tool available. TOAD might be better for the DBA, but for programming, this is your best friend.