Oracle 10053 SQL Trace Viewer

July 26th, 2010

The infamous 10053 trace is probably the most extensive trace for understanding why the Oracle optimizer chose a query’s execution path (also see event 10132 at level 1). The 10053 trace can been large, cumbersome and tedious to read. Finally help is on the way. See Jonathan Lewis’ blog at

(rename and take the “.doc” extension off)


Uncategorized

  1. Trackbacks

  1. Comments

  2. January 9th, 2012 at 23:19 | #1

    Kyle, this maybe relevant. There is another free 10053 trace viewer. It uses a navigation section, similar to the Contents section in PDF viewer, for example. It allows jumping to the most important parts of 10053 trace. It also uses highlighter to improve readability of the trace and optionally formats the final query after transformations. Here is the link: http://www.lab128.com/free_downloads.html
    Regards,
    Sergei

  3. January 9th, 2012 at 23:30 | #2

    Thanks Sergei – great news. I blogged this as its own blog: http://dboptimizer.com/2012/01/09/10053-trace-file-viewer/


3 + = nine