Oracle Database 11g Release 2 Performance Tuning Tips & Techniques

by Richard Niemiec

About the Oracle Database 11g Release 2 Performance Tuning Tips & Techniques Oracle Database 11g Release 2 Performance Tuning Tips & Techniques details 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 Distribute workload using Oracle Real Application Testing Contents Chapter 1. Introduction to 11g R1 and R2 New Features (DBA and Developer) Chapter 2. Basic Index Principles (Beginner Developer and Beginner DBA) Chapter 3. Disk Implementation Methodology and ASM (DBA) Chapter 4. Tuning the Database with Initialization Parameters (DBA) Chapter 5. Enterprise Manager and Grid Control (DBA and Developer) Chapter 6. Using EXPLAIN and SQL PLAN MANAGEMENT (Developer and DBA) Chapter 7. Basic Hint Syntax (Developer and DBA) Chapter 8. Query Developer and Beginner DBA Chapter 9. Table Joins and Other Advanced Tuning (Advanced DBA and Developer) Chapter 10. Using PL/SQL to Enhance Performance (Developer and DBA) Chapter 11. Exadata, Tuning RAC, and Using Parallel Features Chapter 12. The V Views (Developer and DBA) Chapter 13. The X Tables (Advanced DBA) Chapter 14. Using Statspack and the AWR Report to Tune Waits, Latches, and Mutexes Chapter 15. Performing a Quick System Review (DBA) Chapter 16. Monitor the System Using Unix Utilities (DBA) Appendix A. Key Initialization Parameters (DBA) Appendix B. The V Views (DBA and Developer) Appendix C. The X Tables (DBA) Index About the Richard Niemiec Richard Niemiec is an Oracle Ace Director and one of only six originally honored Oracle Cer

Genres: Nonfiction

1180 pages, Paperback

First published February 27, 2012

Reviews

[Justin · Rating 4 out of 5]

I'll start with the good: The book is very comprehensive, and it's evident that the author put a great deal of effort into writing it. A few of the chapters, individually, are worth the price of the book.

Unfortunately, the book is also filled with outdated advice, and statements I had considered flat-out wrong or at the very least ostensible. I actually kept track of these statements but eventually gave up because the list was growing too long; I bought the book to learn more about Oracle performance tuning, not to be a technical editor for it.

In the end, I would recommend this book be used to strengthen your performance tuning knowledge. Use it to supplement the excellent documentation that Oracle makes available free of charge (including the Performance Tuning Guide).

[Delhi Irc]

Location: GG7 IRC
Accession No: DL027508

[Shahzaad Ali · Rating 5 out of 5]

hglhgkgjh,mnbnm

[Arti]

good

[Dilipverma · Rating 5 out of 5]

for DBA good use of this book