TAILIEUCHUNG - Apress Troubleshooting Oracle Performance Jun 2008 1590599179
The Oracle database engine has become a huge piece of software. This not only means that a single human can no longer be roficient in using all the features provided in recent versions, but it also means that some of them will rarely be used. Actually, in most situations, it is enough to know and take advantage of a limited number of core features in order to use the Oracle database engine efficiently and successfully. | cyan yellOW MAGENTA BLACK PANTONE 123 C Books for professionals by professionals® The EXPERT’s VOIce® in Oracle Companion eBook Available Covers OracOraclele DatabaseDatabase Troubleshooting Oracle Performance through Troubleshooting Oracle Performance 9iiR2 through 1111gR1 Dear Reader, What do you do when your application isn’t running fast enough? You trouble- shoot, of course. Finding the slow part of an application is often the easiest part of the battle. The difficult part is finding a solution or, even better, avoiding the performance problem in the first place. Troubleshooting Oracle Performance helps by providing a systematic approach to addressing the underlying causes of poor performance of applications based on the Oracle database engine. Over the last decade I have spent a great deal of my time troubleshooting performance problems. In writing this book, I hope to do three things: first, and most importantly, to share my experience in this area with you; second, to Troubleshooting show a methodical approach that avoids guesswork and helps you determine beyond any doubt where the slow part of an application is; third, to explain how the database engine processes SQL statements and show what features are available to ensure that SQL execution remains efficient. Specifically, this book shows you how to do the following: • Identify performance problems using a systematic and repeatable approach. Oracle • Configure the query optimizer to meet your application performance goals. • Obtain and interpret execution plans as well as assess their efficiency. • Apply SQL tuning techniques such as hints, SQL profiles, stored outlines, and SQL plan baselines. • Minimize the impact of parsing without jeopardizing performance. • Optimize data access, joins, and the physical design of your database. Performance • Improve performance through parallel processing, materialized views, and result caching. Whether you are a performance analyst, an application developer, .
đang nạp các trang xem trước
