Oracle Database Problem Solving and Troubleshooting Handbook

Oracle Database Problem Solving and Troubleshooting Handbook
by Tariq Farooq and Mike Ault
Paperback: 512 pages
Publisher: Addison Wesley; 01 edition (18 April 2016)
Language: English
ISBN-10: 0134429206
ISBN-13: 9780134429205
B01DWFCP3O
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.
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
解决复杂Oracle数据库问题的专家指南
Oracle数据库问题解决和故障排除手册？为复杂的生产环境中可靠，高效地运行Oracle数据库提供了全面，实用且最新的建议。七位领先的Oracle专家汇集了无可比拟的经过验证的解决方案，实践示例以及Oracle Database 12c 11g和其他最新版本的Oracle数据库的分步提示。每个解决方案都是为了帮助经验丰富的Oracle DBA和DMA尽可能快地了解和解决严重问题。
作者涵盖LOB段，UNDO表空间，高GC缓冲区等待事件，查询响应时间差，锁定争用，索引，XA分布式事务，RMAN备份/恢复等等。他们还提供了广泛的主题的深入报道，包括DDL优化，VLDB调优，数据库取证，自适应光标共享，数据泵，数据迁移，SSD，索引以及如何解决Oracle RAC问题。
了解如何
选择最快的途径来解决高影响力的问题
使用现代最佳实践，使您的一天更有效率和可预测性
构建您的“Call 9-1-1计划”，以备将来的数据库紧急情况
主动执行维护以改善环境的稳定性
节省时间与行业标准的工具和脚本
在http://informit.com/register注册您的产品，以方便您下载，更新和更正，以获得可用的访问权限。
目录
第1章故障排除和调优LOB段性能
第2章克服撤销表空间的破坏
第3章处理GC缓冲区忙等待事件
第4章自适应光标共享
第5章使用SQL计划管理稳定查询响应时间
第6章DDL优化技巧，技巧和技巧
第7章管理，优化和调优VLDB
第8章使用Recovery Manager进行备份和恢复的最佳做法
第9章使用AWR分析的数据库取证和调优: 第一部分
第10章使用AWR分析的数据库取证和调优: 第二部分
第11章排除RAC中的问题场景
第12章利用SQL顾问分析和修复SQL问题
第13章扩展用于数据和对象迁移的数据泵
第14章在数据库之间快速迁移数据的策略
第15章从TEMPFILE I / O问题进行诊断和恢复
第16章处理锁存和互斥争议
第17章使用SSD来解决I / O瓶颈
第18章优化性能指标设计和监控指标
第19章使用SQLT来提高查询性能
第20章处理XA分布式事务问题