TAILIEUCHUNG - 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

• Hệ điều hành
• Scripting Cookbook
• Themes Design
• Mapping with Drupal
• Oracle Database 11g
• Performance Tuning Recipes
• A Problem Solution Approach
• Linux Shell
• cookbook style
• recipes
• Linux Shell Scripting Cookbook
• programming tips
• programming languages
• programming basics
• Microsoft Dynamics NAV 2009
• Programming Cookbook
• OpenCV 2
• Computer Vision Application
• O’Reilly Media
• Cookbook
• O’Reilly books
• Linux Command Line
• Richard Blum
• Shell Scripting Bible
• No Starch Map
• Scripting 101 Aug 2010
• JavaScript
• Enlightenment
• JavaScript 1
• Mobile Cookbook
• LPI Linux Certification
• in a Nutshell
• 3rd Edition
• Alan Palazzolo
• Thomas Turnbull
• Microsoft Access 2010
• VBA Programming Inside Out
• Andrew Couch
• Microsoft Access 2013
• Plain & Simple
• Microsoft Dynamics
• AX 2009 Administration
• Paul McFedries
• Microsoft Windows Home Server
• Second Edition
• NumPy 1
• 5
• Beginners Guide
• Oracle Certified Professional Java SE 7
• Programmer Exams
• 1Z0 804 and 1Z0 805
• Oracle Performance Tuning
• 2nd Edition
• Oracle SQL Tuning
• Pocket Reference
• Mark Gurry
• Oracle SQL
• Tuning with Oracle
• SQLTXPLAIN
• Windows Scripting Cookbook
• Windows Home Server