Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach

Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach

Paperback(1st ed.)

$59.99
View All Available Formats & Editions
Choose Expedited Shipping at checkout for guaranteed delivery by Monday, April 29

Product Details

ISBN-13: 9781430236627
Publisher: Apress
Publication date: 08/23/2011
Edition description: 1st ed.
Pages: 592
Sales rank: 936,716
Product dimensions: 7.50(w) x 9.20(h) x 1.30(d)

About the Author

Sam R. Alapati is an experienced Oracle database administrator who holds the Oracle Certified Professional designation and the Hewlett-Packard UNIX System Administrator certification. He currently manages Oracle databases at the Boy Scouts of America's national headquarters in Los Colinas, Texas. Alapati has been dealing with databases for a long time, including the Ingres RDBMS in the mid-1980s. He is also well-versed in the Microsoft SQL Server, Sybase, and IBM DB2 database management systems.

Table of Contents

  1. Optimizing Table Performance
  2. Choosing and Optimizing Indexes
  3. Optimizing Instance Memory
  4. Monitoring System Performance
  5. Minimizing System Contention
  6. Analyzing Operating System Performance
  7. Troubleshooting the Database
  8. Creating Efficient SQL
  9. Manually Tuning SQL
  10. Tracing SQL Execution
  11. Automated SQL Tuning
  12. Execution Plan Optimization and Consistency
  13. Configuring the Optimizer
  14. Implementing Query Hints
  15. ExecutingSQL in Parallel


Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews