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 ...
© Stelios Charalambides 2017
Stelios Charalambides, Oracle SQL Tuning with Oracle SQLTXPLAIN, 10.1007/978-1-4842-2436-6_18
18. Trace Files, TRCANLZR, and Modifying SQLT Behavior
Stelios Charalambides1
(1)New Hampton, New Hampshire, USA
Get Oracle SQL Tuning with Oracle SQLTXPLAIN: Oracle Database 12c Edition, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
