O'Reilly logo

Oracle SQL Tuning with Oracle SQLTXPLAIN by Stelios Charalambides

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 13

image

Trace Files, TRCANLZR and Modifying SQLT behavior

Even with SQLT helping you sometimes you need to look at 10046 trace files and analyze these to determine what’s happening. How you analyze and interpret 10046 files is outside the scope of this book. The standard guide for this is Cary Millsap’s book Optimizing Oracle Performance (O’Reilly 2003). (This book is a little dated now, but still contains useful information on 10046 trace files.) How to more easily collect these trace files, however, and format them so they are easier to interpret is not beyond the scope of this book, as SQLT provides a number of methods for collecting this ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required