Oracle Database 11g Release 2 Performance Tuning Tips & Techniques

by Niemiec, Richard

• ISBN13: 9780071780261
• ISBN10: 0071780262
• Edition: 1st
• Format: Paperback
• Copyright: 2012-03-19
• Publisher: McGraw-Hill Education

Summary

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