Oracle Database 11g Release 2 Performance Tuning Tips & Techniques

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 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

• 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