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 email@example.com. 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.
DownloadThe application is built in JavaFX and is supplied as a zip file containing a custom JRE, so should not need any dependencies to run. Download the version for your operating system below, unzip to a suitable location, and then run the bin/otfb.bat (Windows) or bin/otfb (Mac/Linux) script to launch the application.
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
|0.7α||02/03/2020||Enhanced to handle multiple binds for bulk operations.|
|0.6α||18/02/2020||Fixed out of memory error from pie charts.|
|0.5α||30/12/2019||Migrated to JavaFX 13.|
|0.4α||18/10/2019||Fixed to handle object identifiers duplicated between a CDB and PDB.|
|0.3α||14/08/2019||Tested on files up to Oracle Database 19c, performance improvements, and re-factoring of timestamp calculation.|
|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.|