Oracle Database Problem Solving and Troubleshooting Handbook
by Tariq Farooq, Mike Ault, Paulo Portugal, Mohamed Houri, Syed Jaffar Hussain, Jim Czuprynski, Guy Harrison
Overview
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 informit.com/register for convenient access to downloads, updates, and corrections as they become available.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access