Oracle Database 11g Release 2 Performance Tuning Tips & Techniques (Oracle Press) (Paperback) - Common

by Richard Niemiec

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 & 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 11"g" 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 reports using Oracle's Statspack and Automatic Workload Repository tools Use sar, vmstat, and iostat to monitor system statistics

"This is a timely update of Rich's classic book on Oracle Database performance tuning to cover hot new topics like Oracle Database 11g Release 2 and Oracle Exadata. This is a must-have for DBAs moving to these new products." --Andrew Mendelsohn, Senior Vice President, Oracle Database Server Technologies

Genres: Nonfiction

1184 pages, Unknown Binding

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