Oracle Database 11g Release 2 Performance Tuning Tips & Techniques

As with previous versions of this Oracle Press bestseller, "Oracle Database 11g Performance Tuning Tips & Techniques" provides instructions that explain the best ways of maintaining a high-performance Oracle Database 11"g" environment using proven tuning methods. Oracle Certified Master Richard Niemiec offers hundreds of essential tips to enhance system performance and an array of real-world examples to illustrate insider best practices. The in-depth details highlight the new tuning options available for optimizing Oracle Database11"g" and 11"g"R2. Intermediate-to-advanced database administrators and developers will write faster, cleaner code and build radically more efficient, secure, and durable systems with help from this definitive resource.

"Oracle Database 11g Performance Tuning Tips & Techniques"Contains approximately 35% new materialWritten by one of the most popular Oracle experts in the world Helps working professionals quickly and easily apply the tips to specific and immediate problems faced by most administrators and developersCovers all the new features in Oracle Database 11"g" + 11"g"R2Features thumb tabs that make it easy to scan for and quickly access specific tips

Complete coverage:
Introduction to 11"g" New Features (DBA and Developer); Basic Index Principles (Beginner Developer and Beginner DBA); Finding Disk I/O Bottlenecks; Initialization Parameters and Tuning; Oracle Enterprise Manager; Using EXPLAIN and SQL PLAN MANAGEMENT (Developer and DBA); Using Hints for Query Tuning; Query Tuning: Developer and Beginner DBA; Table Joins & other Advanced Tuning; Using PL/SQL to Enhance Performance; Exadata, Exalogic, Tuning RAC & Parallel Features; V$ Views and Tuning; The X$ Tables (Advanced DBA); Using AWR & Statspack to Tune Waits & Latches; Performing a Quick System Review; Monitoring the system using UNIX Utilities Less