9780071780261

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

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

What is included with this book?

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 Used, Rental and eBook copies of this book are 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.

Amazon no longer offers textbook rentals. We do!

Oracle Database 11g Release 2 Performance Tuning Tips & Techniques

Oracle Database 11g Release 2 Performance Tuning Tips & Techniques

0071780262

Summary

Table of Contents

Supplemental Materials