Oracle Database 11g Release 2 Performance Tuning Tips & Techniques

  • ISBN13:


  • ISBN10:


  • Edition: 1st
  • Format: Paperback
  • Copyright: 2012-03-19
  • Publisher: McGraw-Hill Education
  • View Upgraded Edition
  • Purchase Benefits
  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $62.00 Save up to $9.30
  • Buy New
    Add to Cart Free Shipping


Supplemental Materials

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 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
Appendix A: Key Initialization Parameters
Appendix B: V$ Views and Descriptions
Appendix C: X$ Tables and Descriptions

Rewards Program

Write a Review