Đang chuẩn bị liên kết để tải về tài liệu:
Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach

Oracle Database 11g Performance Tuning Recipes is a ready reference for database administrators in need of immediate help with performance issues relating to Oracle Database. The book takes an example-based approach, wherein each chapter covers a specific problem domain. Within each chapter are "recipes," showing by example how to perform common tasks in that chapter’s domain. Solutions in the recipes are backed by clear explanations of background and theory from the author team. Whatever the task, if it’s performance-related, you’ll probably find a recipe and a solution in this book | THE EXPERT S VOICE IN ORACLE Oracle Database 11 g Performance Tuning Recipes A Problem-Solution Approach TESTED SOLUTIONS TO COMMON ORACLE DATABASE PERFORMANCE PROBLEMS Sam R. Alapati Dari Kuhn and Bill Padfield Apress Contents at a Glance About the Authors.xvi About the Technical Reviewer.xvii Acknowledgments.xviii Chapter 1 Optimizing Table Performance.1 Chapter 2 Choosing and Optimizing Indexes.43 Chapter 3 Optimizing Instance Memory.83 Chapter 4 Monitoring System Performance.113 Chapter 5 Minimizing System Contention.147 Chapter 6 Analyzing Operating System Performance.185 Chapter 7 Troubleshooting the Database.209 Chapter 8 Creating Efficient SQL.253 Chapter 9 Manually Tuning SQL.299 Chapter 10 Tracing SQL Execution.327 Chapter 11 Automated SQL Tuning.367 Chapter 12 Execution Plan Optimization and Consistency.409 Chapter 13 Configuring the Optimizer.447 Chapter 14 Implementing Query Hints.491 Chapter 15 Executing SQL in Parallel.525 Index.555 iv www.it-ebooks.info CHAPTER1 Optimizing Table Performance This chapter details database features that impact the performance of storing and retrieving data within a table. Table performance is partially determined by database characteristics implemented prior to creating tables. For example the physical storage features implemented when first creating a database and associated tablespaces subsequently influence the performance of tables. Similarly performance is also impacted by your choice of initial physical features such as table types and data types. Therefore implementing practical database tablespace and table creation standards with performance in mind forms the foundation for optimizing data availability and scalability. An Oracle database is comprised of the physical structures used to store manage secure and retrieve data. When first building a database there are several performance-related features that you can implement at the time of database creation. For example the initial layout of the datafiles and the