The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
The eBook copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.
Implement Proven Database Optimization Solutions Systematically identify and eliminate database performance problems with help from Oracle Certified Master, Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 11g Release 2 Performance Tuning Tips & Techniquesdetails the latest monitoring, troubleshooting, and optimization methods. Find out how to find and fix bottlenecks, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered in this Oracle Press guide. Properly index and partition Oracle Database 11g Release 2 Work with Oracle Exadata and Oracle Exalogic Elastic Cloud Efficiently manage disk drives, RAID arrays, and memory Tune queries with Oracle SQL hints and the TRACE utility Troubleshoot databases using V$ views and X$ tables Distribute workload using Oracle Real Application Testing Generate Oracle Statspack and automatic workload repository reports Use sar, vmstat, and iostat to monitor system statistics
Table of Contents
Chapter 1: Introduction to 11g New Features (DBA and Developer) Chapter 2: Basic Index Principles(Beginner Developer and Beginner DBA) Chapter 3: Finding Disk I/O Bottlenecks Chapter 4: Initialization Parameters and Tuning Chapter 5: Oracle Enterprise Manager Chapter 6: Using EXPLAIN and SQL PLAN MANAGEMENT (Developer and DBA) Chapter 7: Using Hints for Query Tuning Chapter 8: Query Tuning: Developer and Beginner DBA Chapter 9: Table Joins & other Advanced Tuning Chapter 10: Using PL/SQL to Enhance Performance Chapter 11: Exadata, Exalogic, Tuning RAC & Parallel Features Chapter 12: V$ Views and Tuning Chapter 13: The X$ Tables (Advanced DBA) Chapter 14: Using AWR & Statspack to Tune Waits & Latches Chapter 15: Performing a Quick System Review Chapter 16: Monitoring the system using UNIX Utilities Appendixes Appendix A: Key Initialization Parameters Appendix B: V$ Views and Descriptions Appendix C: X$ Tables and Descriptions