© Stelios Charalambides  2017

Stelios Charalambides, Oracle SQL Tuning with Oracle SQLTXPLAIN, 10.1007/978-1-4842-2436-6_1

1. Introduction

Stelios Charalambides

(1)New Hampton, New Hampshire, USA

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. ...

Get Oracle SQL Tuning with Oracle SQLTXPLAIN: Oracle Database 12c Edition, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.