Oracle Database Problem Solving and Troubleshooting Handbook

An Expert Guide for Solving Complex Oracle Database Problems

Oracle Database Problem Solving and Troubleshooting Handbook ?delivers comprehensive, practical, and up-to-date advice for running the Oracle Database reliably and efficiently in complex production environments. Seven leading Oracle experts have brought together an unmatched collection of proven solutions, hands-on examples, and step-by-step tips for Oracle Database 12c, 11g, and other recent versions of Oracle Database. Every solution is crafted to help experienced Oracle DBAs and DMAs understand and fix serious problems as rapidly as possible.

The authors cover LOB segments, UNDO tablespaces, high GC buffer wait events, poor query response times, latch contention, indexing, XA distributed transactions, RMAN backup/recovery, and much more. They also offer in-depth coverage of a wide range of topics, including DDL optimization, VLDB tuning, database forensics, adaptive cursor sharing, data pumps, data migration, SSDs, indexes, and how to go about fixing Oracle RAC problems.

Learn how to

• Choose the quickest path to solve high-impact problems
• Use modern best practices to make your day more efficient and predictable
• Construct your “Call 9-1-1 plan” for future database emergencies
• Proactively perform maintenance to improve your environment’s stability
• Save time with industry-standard tools and scripts

Register your product at http://informit.com/register for convenient access to downloads, updates, and corrections as they become available.

Table of Contents

Chapter 1 Troubleshooting and Tuning LOB Segment Performance
Chapter 2 Overcoming Undo Tablespace Corruption
Chapter 3 Handling GC Buffer Busy Wait Events
Chapter 4 Adaptive Cursor Sharing
Chapter 5 Stabilizing Query Response Time Using SQL Plan Management
Chapter 6 DDL Optimization Tips, Techniques, and Tricks
Chapter 7 Managing, Optimizing, and Tuning VLDBs
Chapter 8 Best Practices for Backup and Recovery with Recovery Manager
Chapter 9 Database Forensics and Tuning Using AWR Analysis: Part I
Chapter 10 Database Forensics and Tuning Using AWR Analysis: Part II
Chapter 11 Troubleshooting Problematic Scenarios in RAC
Chapter 12 Leveraging SQL Advisors to Analyze and Fix SQL Problems
Chapter 13 Extending Data Pump for Data and Object Migration
Chapter 14 Strategies for Migrating Data Quickly between Databases
Chapter 15 Diagnosing and Recovering from TEMPFILE I/O Issues
Chapter 16 Dealing with Latch and Mutex Contention
Chapter 17 Using SSDs to Solve I/O Bottlenecks
Chapter 18 Designing and Monitoring Indexes for Optimal Performance
Chapter 19 Using SQLT to Boost Query Performance
Chapter 20 Dealing with XA Distributed Transaction Issues