Oracle Trace File Browsers?

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

TKProf is great for summary information, but lately I need more details about a particular instruction run and end up returning to the trace file directly. Summing and filtering would be pros, but basically looking for something with some basic details for each statement.

I came across a trace browser in SQL Developer 1.5.5. It would be ideal if it didn't take minutes to download files with multiple megabytes.

I have Toad 9.x, but I cannot link to the utilities to view the trace files, I may not have this license. Like many other features, I find hints in it in the online help, but I can't find the menu choices they mention in the help file, or a clear connection to what needs to be licensed to enable this feature.

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

+2


source to share


1 answer


Allround Automations "PL / SQL Developer has a graphical interface for viewing traces. I've only used it for small footprints, but it seems pretty fast.



There is a trial version available for download from their site, I would recommend trying it out and see how it works for you. My company bought us licenses and honestly if you are developing PL / SQL this is the best tool. TOAD may be better for a DBA, but for programming, it's your best friend.

+3


source







All Articles