DB Optimizer: Oracle 10053 SQL Trace Viewer

Monday, July 26, 2010

Oracle 10053 SQL Trace Viewer

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)

No comments:

Post a Comment

Kyle Hailey

I'm Kyle Hailey and I'm the designer and product manager behind Embarcadero's

DB Optimzer

Before working at Embarcadero I redesigned the performance pages in Oracles OEM 10g (see a before and after example). I am on the patent from the team for our tuning methodology (Patents: 20060059205) . I freely provide graphical monitoring tools such as ASHMON (TCL/TK) as well as scripts to profile database load such as S-ASH ie Simulated ASH (PLSQL). S-ASH, ASHMON and more are available at my old site http://ashmasters.com/ . I have made available C code to directly read profiling data out of Oracle's memory structures, called Direct Memory Access. I speak at conferences and give classes around the world.This blog has some of my new ideas on Visual SQL Tuning (VST), work on DB Optimizer, possibly some past material on DB performance monitoring as well as lots of references and pointers to other information on the web that I find important and worth emphasizing.

DB Optimizer

Monday, July 26, 2010

Oracle 10053 SQL Trace Viewer

No comments:

Post a Comment

The Oaktable

Oracle "deep dive" search by T. Pystynen

My Blog List

Facebook

Kyle Hailey