Oracle Database 11g Release 2 Performance Tuning Tips & Techniques

by Richard Niemiec

Implement Proven Database Optimization SolutionsSystematically 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 & 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 2Work with Oracle Exadata and Oracle Exalogic Elastic CloudEfficiently manage disk drives, RAID arrays, and memoryTune queries with Oracle SQL hints and the TRACE utilityTroubleshoot databases using V$ views and X$ tablesDistribute workload using Oracle Real Application TestingGenerate reports using Oracle's Statspack and Automatic Workload Repository toolsUse sar, vmstat, and iostat to monitor system statistics

Genres: Nonfiction

1184 pages, ebook

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