Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to tune even the most complex SQL, and you'll learn to do it quickly, without the huge learning curve usually associated with tuning as a whole. Firmly based in real world problems, this book helps you reclaim system resources and avoid the most common bottleneck in overall performance, badly tuned SQL. You'll learn how the optimizer works, how to take advantage of its latest features, and. | THE EXPERT S VOICE IN ORACLE Oracle SQL Tuning with Oracle SQLTXPLAIN THE FAST AND EASY WAY TO TUNE SQL LIKE A PRO Stelios Charalambides _____________ Apress www.it-ebooks.info For your convenience Apress has placed some of the front matter material after the index. Please use the Bookmarks and Contents at a Glance links to access them. Apress www.it-ebooks.info Contents at a Glance About the Author.xv About the Technical Reviewer.xvii Acknowledgments.xix Foreword.xxi Introduction.xxv Chapter 1 Introduction to SQLTXPLAIN.1 Chapter 2 The Cost-Based Optimizer Environment.17 Chapter 3 How Object Statistics Can Make Your Execution Plan Wrong.39 Chapter 4 How Skewness Can Make Your Execution Times Variable.53 Chapter 5 Troubleshooting Query Transformations.71 Chapter 6 Forcing Execution Plans Through Profiles.93 Chapter 7 Adaptive Cursor Sharing.111 Chapter 8 Dynamic Sampling and Cardinality Feedback.129 Chapter 9 Using SQLTXPLAIN with Data Guard Physical Standby Databases.147 Chapter 10 Comparing Execution Plans.163 Chapter 11 Building Good Test Cases.177 Chapter 12 Using XPLORE to Investigate Unexpected Plan Changes.205 Chapter 13 Trace Files TRCANLZR and Modifying SQLT behavior.231 v .
