Oracle database problem solving and troubleshooting handbook
By: Tariq Farooq [and 6 others]
Publisher: Addison-Wesley Professional
Published: 2016
Language: eng
Number of pages: 481
ISBN-13: 9780134429205
Subjects: Relational databases; SQL (Computer program language); Oracle (Computer file)
Description: 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. -- Provided by publisher.
Notes: Includes index.
Table of contents: title: Troubleshooting and tuning LOB segment performance; title: Overcoming UNDO tablespace corruption; title: Handling GC buffer busy wait events; title: Adaptive cursor sharing; title: Stabilizing query response time using SQL plan management; title: DDL optimization tips, techniques, and tricks; title: Managing, optimizing, and tuning VLDBs; title: Best practices for backup and recovery with recovery manager; title: Database forensics and tuning using AWR analysis; title: part I; title: Database forensics and tuning using AWR analysis; title: part II; title: Troubleshooting problematic scenarios in RAC; title: Leveraging SQL advisors to analyze and fix SQL problems; title: Extending data pump for data and object migration; title: Strategies for migrating data quickly between databases; title: Diagnosing and recovering from TEMPFILE I/O issues; title: Dealing with Latch and Mutex contention; title: Using SSDs to solve IO bottlenecks; title: Designing and monitoring indexes for optimal performance; title: Using SQLT to boost query performance; title: Dealing with XA distributed transaction issues.