Oracle Database 11g Release 2 Performance Tuning Tips & Techniques

The most trusted name in performance tuning updates his bestselling guide for the challenges of Oracle Database 11g + 11gR2.

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 11g 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 Database11g and 11gR2. 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 material
• Written 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 developers
• Covers all the new features in Oracle Database 11g + 11gR2
• Features thumb tabs that make it easy to scan for and quickly access specific tips

Complete coverage:
Introduction to 11g 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