Introduction

  • Stelios Charalambides
Chapter

Abstract

Welcome to the world of fast Oracle SQL tuning with SQLT. 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 the SQL is malfunctioning, and finally, to knowing how to fix the SQL. This of course assumes that your SQL can run faster. Some SQLs are just doing their best with the data and what you are asking them to do. It’s not miraculous, but it’s pretty close.

Keywords

Plan Section Nest Loop Execution Plan Trace File Tuning Problem 
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.

Copyright information

© Stelios Charalambides  2017

Authors and Affiliations

  • Stelios Charalambides
    • 1
  1. 1.New HamptonUSA

Personalised recommendations