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

Introduction

This book is intended as a practical guide to an invaluable tool called SQLTXPLAIN, commonly known simply as SQLT. You may never have heard of it, but if you have anything to do with Oracle tuning, SQLT is one of the most useful tools you’ll find. Best of all, it’s freely available from Oracle. All you need to do is learn how to use it.

How This Book Came to Be Written

I’ve been a DBA for over twenty years. In that time, I dealt with many, many tuning problems yet it was only when I began to work for Oracle that I learned about SQLT. As a part of the tuning team at Oracle Support I used SQLT every day to solve customers’ most complex tuning problems. I soon realized that my experience was not unique. Outside Oracle, few DBAs knew ...

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