Advertisement

Introduction to SQLTXPLAIN

  • Stelios Charalambides

Abstract

Welcome to the world of fast Oracle SQL tuning with SQLTXPLAIN, or SQLT as it is typically called. Never heard of SQLT? You’re not alone. I’d never heard of it before I joined ORACLE, and I had been a DBA for more years than I care to mention. That’s why I’m writing this book. SQLT is a fantastic tool because it helps you diagnose tuning problems quickly. What do I mean by that? I mean that in half a day, maximum, you can go from a slow SQL to having an understanding of why SQL is malfunctioning, and finally, to knowing how to fix the SQL.

Keywords

Execution Plan Trace File Full Table Tuning Problem Equality Predicate 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Stelios Charalambides 2013

Authors and Affiliations

  • Stelios Charalambides

There are no affiliations available

Personalised recommendations