Oracle Trace File Browser

Screenshot

This application is a browser for trace files produced by the Oracle RDBMS. Currently it works for 10046 extended trace files, but may be enhanced in the future to handle other types.

Once a trace file has been opened, the left side of the window has a table of the events in the file. The display is hierarchical to show the relationship between events that occur within another event, such as for recursive SQL. Double-click on a "+" to expand an event to see those within it; and double-click on a "-" to collapse the list again.

Clicking an event to select it updates the event information in the top-right panel. There are tabs for event details, SQL statement, bind values and execution plan; though not all tabs apply to every event.

The bottom-right panel shows an analysis of the events. There are tabs for top SQL, top events, top waits and top objects. Double-click a row in the top SQL tab to show the analysis for just that SQL statement. Double-click an event, wait or object row to see a histogram of the times for that item.

Sometimes a trace file contains events outside the period of interest. In order to restrict the analysis to part of the file, right-click in the event table to specify the selected event as the start or end of the analysis. For an event with other events within it, setting it as the start event for analysis actually sets this to be the earliest of all the contained events. The start and end events for analysis are highlighted in green.

Warning! At present this is an alpha release of the application, which means it is very likely to give a warning when loading your trace file. If so, it will have attempted to load the file in permissive mode, which means it ignores errors. Some errors are inconsequential, such as failing to parse a bind value; however others may lead to an incomplete file being loaded and thus an invalid analysis. To help improve the application, please send any trace files that fail to load to otfb@mike-francis.co.uk. They will of course be treated in confidence, and only used for the purpose of testing the application. If the application is licensed in the future, anyone who has provided a trace file that resulted in a fix to the application will be granted a perpetual licence at no cost.

Download

oratracefilebrowser.jar

The application is built in JavaFX, and requires Java version 8 Update 60 or later. For Linux users please note that the Oracle Java download is required; it is not sufficient to install OpenJDK as that does not include JavaFX.

If double-clicking the downloaded JAR file does not work, start the application with:

java -jar oratracefilebrowser.jar

If you do not have a trace file at hand to try out the application, here is a sample file that was created to test how various data types appear as binds: otfb_sample_binds.trc

Release History

Version Date Description
0.2α 28/08/2017 Processes files where the client context set by the application changes during the course of the trace.
0.1α 28/05/2015 First public alpha release.