Oracle Database Problem Solving and Troubleshooting Handbook

By: Mike Ault, Jim Czuprynski, Guy Harrison, Syed Jaffar Hussain, Mohamed Houri, Paulo Portugal, Biju Thomas, Tariq Farooq

ISBN-13: 9780134429205
ISBN-10: 0134429206
Publisher: Addison-Wesley Professional
Published date: 2016-02-15
If you’re responsible for running Oracle reliably and efficiently in a complex production environment, Oracle Problem Solving and Troubleshooting Handbook offers you more practical, usable help than any other book. Eight world-class Oracle experts have brought together an unprecedented collection of real-world solutions, hands-on examples, and step-by-step tuning and troubleshooting tips for Oracle 12c, 11g, and other recent versions of the Oracle database. All of this handbook’s solutions share one guiding principle: to help you fix serious problems as rapidly as possible. The authors present rapid-fire solutions to a wide range of real-world problems, explaining each of them with exceptional simplicity and clarity. You’ll learn today’s best ways to solve problems with LOB segments, UNDO tablespaces, high GC buffer wait events, poor query response times, latch contention, indexing, XA distributed transactions, RMAN backup/recovery problems, and much more. The authors also offer in-depth coverage of adaptive cursor sharing, DDL optimization, VLDB tuning, database forensics/tuning, data pumps, data migration, SSDs, indexes, fixing Oracle RAC “nightmare scenarios,” and much more. For modern Oracle DBAs and DMAs, this book is, quite simply, indispensable.