(0) items

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Oracle Database 11g Release 2 Performance Tuning Tips & Techniques



Pub. Date:
McGraw-Hill Education
List Price: $62.00

Buy New Book

In Stock Usually Ships in 24 Hours



Rent Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

More New and Used
from Private Sellers
Starting at $18.95

Questions About This Book?

What version or edition is this?

This is the 1st edition with a publication date of 3/19/2012.

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 CDs, lab manuals, study guides, etc.
  • The eBook copy of this book is not guaranteed to include any supplemental materials. Typically only the book itself is included.

  • Oracle Database 10g Performance Tuning Tips & Techniques
    Oracle Database 10g Performance Tuning Tips & Techniques


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

Please wait while the item is added to your cart...