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
Oracle Performance Tuning, 2nd Edition
The books in O'Reilly's Oracle series are authoritative -- they tell the whole story about complex …
book
Oracle Database 11gR2 Performance Tuning Cookbook
Shifting your Oracle Database into top gear takes a lot of know-how and fine-tuning ability. The …
book
Oracle PL/SQL Performance Tuning Tips & Techniques
Proven PL/SQL Optimization Solutions In Oracle PL/SQL Performance Tuning Tips & Techniques, Oracle ACE authors with …