Book description
Troubleshoot, tune, and optimize your Oracle database efficiently and successfully every time. This book explains how to take full advantage of the revolutionary Oracle Wait Interface to quickly pinpoint--and solve--core problems and bottlenecks, and increase productivity exponentially.
Table of contents
- Cover Page
- Oracle Wait Interface
- Copyright Page
- Dedication
- Contents
- Foreword
- Acknowledgments
- Introduction
- 1 Introduction to Oracle Wait Interface
- 2 Oracle Wait Interface Components
-
3 Common Wait Events
-
Introduction to Common Wait Events
- buffer busy waits
- control file parallel write
- db file parallel read
- db file parallel write
- db file scattered read
- db file sequential read
- db file single write
- direct path read
- direct path write
- enqueue
- free buffer waits
- latch free
- library cache pin
- library cache lock
- log buffer space
- log file parallel write
- log file sequential read
- log file switch (archiving needed)
- log file switch (checkpoint incomplete)
- log file switch completion
- log file sync
- SQL*Net message from client
- SQL*Net message to client
- Common Wait Events in Oracle Real Application Clusters Environment
- Tracking CPU and Other Statistics
- In a Nutshell
-
Introduction to Common Wait Events
-
4 OWI Monitoring and Collection Methods
- Why Is Historical Performance Data Important?
- Fast and Accurate Root Cause Analysis
- Why Trace Event 10046 Is Not a Suitable Data Collector
- Why Statspack Is Not a Suitable Data Collector
- Database Logoff Trigger as a Data Collector
- Sampling for Performance Data Using PL/SQL Procedure
- Sampling for Performance Data with SQL-less SGA Access
- In a Nutshell
- 5 Interpreting Common I/O Related Wait Events
-
6 Interpreting Locks-Related Wait Events
-
Latch Free
- What Is a Latch?
- Differences between a Latch and a Lock
- Latch Family
- Latch Acquisition
- Latch Classification
- What Does the Latch Free Wait Event Tell You?
- Latch Miss Locations
- Latches in Oracle Database 10g Release 1
- Common Causes, Diagnosis, and Actions
- Shared Pool and Library Cache Latches
- Cache Buffers Chains Latches
- Cache Buffers Lru Chain Latches
- Row Cache Objects Latches
- Enqueue
- Buffer Busy Waits
- In a Nutshell
-
Latch Free
- 7 Interpreting Common Latency-Related Wait Events
- 8 Wait Events in a Real Application Clusters Environment
- 9 Performance Management in Oracle Database 10g
- A Oracle Database 10g Diagnostic Events
- B Enqueue Waits in Oracle Database 10g
- C Oracle Dumps and Traces
- D Direct SGA Access
- E References
- Index
Product information
- Title: Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning
- Author(s):
- Release date: July 2004
- Publisher(s): McGraw Hill Computing
- ISBN: 9780071483759
You might also like
book
Oracle Database 11g Release 2 Performance Tuning Tips & Techniques
Implement Proven Database Optimization Solutions Systematically identify and eliminate database performance problems with help from Oracle …
book
Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach
Performance problems are rarely "problems" per se. They are more often "crises" during which you're pressured …
book
Oracle Data Guard 11g Handbook
Master Oracle Data Guard 11 g Provide superior data protection, availability, and disaster recovery using the …
book
Pro Oracle Database 11g RAC on Linux
Pro Oracle Database 11g RAC on Linux provides full-life-cycle guidance on implementing Oracle Real Application Clusters …