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

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

<h4>Implement Proven Database Optimization Solutions</h4> <p>Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, <i>Oracle Database 11g Release 2 Performance Tuning Tips & Techniques</i> 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.</p> <ul> <li>Properly index and partition Oracle Database 11<i>g</i> Release 2</li> <li>Work with Oracle Exadata and Oracle Exalogic Elastic Cloud</li> <li>Efficiently manage disk drives, RAID arrays, and memory</li> <li>Tune queries with Oracle SQL hints and the TRACE utility</li> <li>Troubleshoot databases using V$ views and X$ tables</li> <li>Distribute workload using Oracle Real Application Testing</li> <li>Generate reports using Oracle's Statspack and Automatic Workload Repository tools</li> <li>Use sar, vmstat, and iostat to monitor system statistics</li> </ul> <p>“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</p>