One might say that developing profiler tools for analyzing extended SQL trace files has been en vogue for the last few years. TKPROF, Oracle’s own profiler has seen only marginal improvements since it first supported wait events in Oracle9i. Other tools offer a much more profound analysis of trace files than TKPROF. First of all there is Oracle’s free Trace Analyzer (see Metalink note 224270.1). This PL/SQL-based tool creates a very detailed HTML report. The downside is that it needs to be installed into a database, which may preclude an ad-hoc analysis of a production system. Ideally it is run in the same instance that was traced, since it will then translate object identifiers into the corresponding segment names.