xxv
Introduction
is 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 nd. 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 that SQLT existed. An even smaller number knew how to use it. Hence the need for this book.
Don’t Buy This Book
If you’re looking for a text on abstract tuning theory or on how to tune “raw” SQL. is book is about how to use SQLT
to do Oracle SQL tuning. e approach used is entirely practical and uses numerous examples to show the SQLT tool
in action.
Do Buy This Book
If you’re a developer or a DBA and are involved with Oracle SQL tuning problems. No matter how complex your
system or how many layers of technology there are between you and your data, getting your query to run eciently
is where the rubber meets the road. Whether you’re a junior DBA, just starting your career, or an old hand who’s seen
it all before, this book is designed to show you something completely practical that will be useful in your day-to-day
work.
An understanding of SQLT will radically improve your ability to solve tuning problems and will also give you an
eective checklist to use against new code and old.
Tuning problems are among the most complex technical problems around. SQLTXPLAIN is a fantastic tool that
will help you solve them. Prepare to be smitten.
www.it-ebooks.info
我的内容管理
收起
我的收益 登录查看自己的收益
我的积分
登录查看自己的积分
我的C币
登录后查看C币余额
我的收藏 
我的下载 
下载帮助 
评论0