tailieunhanh - 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 About the Technical Chapter 1 Optimizing Table Chapter 2 Choosing and Optimizing Chapter 3 Optimizing Instance Chapter 4 Monitoring System Chapter 5 Minimizing System Chapter 6 Analyzing Operating System Chapter 7 Troubleshooting the Chapter 8 Creating Efficient Chapter 9 Manually Tuning Chapter 10 Tracing SQL Chapter 11 Automated SQL Chapter 12 Execution Plan Optimization and Chapter 13 Configuring the Chapter 14 Implementing Query Chapter 15 Executing SQL in iv 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