Oracle 10053 SQL Trace Viewer

July 26th, 2010
Goto comments Leave a comment

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

http://jonathanlewis.wordpress.com/2010/04/30/10053-viewer/
download at http://www.oaktable.net/sites/default/files/new_treeview.zip.doc
(rename and take the “.doc” extension off)


Uncategorized

  1. Trackbacks

  2. January 9th, 2012: DB Optimizer » 10053 Trace file viewer
  3. July 28th, 2019: Instagram Followers: Their Benefits and Why the Cheat is Necessary | buyinstagramsfollowersfast.com

  1. Comments

  2. Sergei Romanenko
    January 9th, 2012 at 23:19 | #1
    Reply | Quote

    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. Kyle Hailey
    January 9th, 2012 at 23:30 | #2
    Reply | Quote

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


seven − = 4