Title Page
by Guy Harrison, Jim Czuprynski, Syed Jaffar Hussain, Mohamed Houri, Paulo Portugal
Oracle Database Problem Solving and Troubleshooting Handbook
- About This E-Book
- Title Page
- Copyright Page
- Contents
- Preface
- Acknowledgments
- About the Authors
- About the Technical Reviewers and Contributors
- 1. Troubleshooting and Tuning LOB Segment Performance
- 2. Overcoming Undo Tablespace Corruption
- 3. Handling GC Buffer Busy Wait Events
- 4. Adaptive Cursor Sharing
- 5. Stabilizing Query Response Time Using SQL Plan Management
- 6. DDL Optimization Tips, Techniques, and Tricks
- 7. Managing, Optimizing, and Tuning VLDBs
- 8. Best Practices for Backup and Recovery with Recovery Manager
- 9. Database Forensics and Tuning Using AWR Analysis: Part I
- What Is AWR?
- Knowing What to Look For
- Header Section
- RAC-Specific Pages
- Time Model Statistics
- Operating System Statistics
- The SQL Sections
- Instance Activity Statistics
- Consistent Get Statistics
- DB Block Get Statistics
- Dirty Block Statistics
- Enqueue Statistics
- Execution Count
- Free Buffer Statistics
- Global Cache (GC) Statistics
- Index Scan Statistics
- Leaf Node Statistics
- Open Cursors
- Parse Statistics
- Physical Read and Write Statistics
- Recursive Statistics
- Redo-Related Statistics
- Session Cursor Statistic
- Sort Statistics
- Summed Dirty Queue Length
- Table Fetch Statistics
- Transaction Rollback
- Undo Change Vector Statistic
- User Statistics
- Work Area Statistics
- Instance Activity Statistics—Absolute Values
- Instance Activity Statistics—Thread Activity
- Summary
- 10. Database Forensics and Tuning Using AWR Analysis: Part II
- Tablespace I/O Statistics
- Buffer Pool Statistics
- PGA Statistics
- Shared Pool Statistics
- Other Advisories
- Buffer Waits Statistics
- Enqueue Statistics
- Undo Segment Statistics
- Latch Statistics
- Segment Access Areas
- Library Cache Activity Sections
- Dynamic Memory Components Sections
- Process Memory Sections
- Streams Component Sections
- Resource Limits Statistics
- Initialization Parameter Changes
- Global Enqueue and Other RAC Sections
- Global Enqueue Statistics
- Global CR Served Statistics
- Global Current Served Statistics
- Global Cache Transfer Statistics
- Global Cache Transfer Times
- Global Cache Transfer (Immediate)
- Global Cache Times (Immediate)
- Interconnect Ping Latency Statistics
- Interconnect Throughput by Client
- Interconnect Device Statistics
- Summary
- 11. Troubleshooting Problematic Scenarios in RAC
- Troubleshooting and Tuning RAC
- Start with ORAchk
- Employ the TFA Collector Utility
- Utilize the Automatic Diagnostic Repository
- Check the Alert and Trace Log Files
- Employ the Three A’s
- Check the Private Cluster Interconnect
- Enable Tracing and Inspect the Trace Logs
- Utilize the Cluster Health Monitor
- Miscellaneous Tools and Utilities
- Useful My Oracle Support Resources
- A Well-Oiled RAC Ecosystem
- Troubleshooting RAC with OEM 12c
- Utilities and Commands for Troubleshooting
- Summary
- Troubleshooting and Tuning RAC
- 12. Leveraging SQL Advisors to Analyze and Fix SQL Problems
- 13. Extending Data Pump for Data and Object Migration
- 14. Strategies for Migrating Data Quickly between Databases
- 15. Diagnosing and Recovering from TEMPFILE I/O Issues
- 16. Dealing with Latch and Mutex Contention
- 17. Using SSDs to Solve I/O Bottlenecks
- 18. Designing and Monitoring Indexes for Optimal Performance
- 19. Using SQLT to Boost Query Performance
- 20. Dealing with XA Distributed Transaction Issues
- Index
- Code Snippets
Oracle Database Problem Solving and Troubleshooting Handbook
Tariq Farooq
Mike Ault
Paulo Portugal
Mohamed Houri
Syed Jaffar Hussain
Jim Czuprynski
Guy Harrison
Boston • Columbus • Indianapolis • New York • San Francisco • Amsterdam • Cape Town
Dubai • London • Madrid • Milan • Munich • Paris • Montreal • Toronto • Delhi • Mexico City
São Paulo • Sidney • Hong Kong • Seoul • Singapore • Taipei • Tokyo
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.