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
Troubleshooting Oracle Performance, Second Edition
Troubleshooting Oracle Performance, 2nd Edition is your systematic guide to diagnosing and resolving performance problems in …
book
Expert Oracle RAC Performance Diagnostics and Tuning
" Expert Oracle RAC Performance Diagnostics and Tuning provides comprehensive coverage of the features, technology and …
book
Oracle Database 12c Release 2 Performance Tuning Tips & Techniques
Proven Database Optimization Solutions―Fully Updated for Oracle Database 12c Release 2 Systematically identify and eliminate database …
book
Troubleshooting Oracle Performance
What do you do when your database application isn't running fast enough? You troubleshoot, of course. …