Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series) - page 1
- 1
- 2
- Table of Contents
- Table of Contents
- BackCover
- Oracle Wait Interface - A Practical Guide to Performance Diagnostics Tuning
- Foreword
- Introduction
- Chapter 1: Introduction to Oracle Wait Interface
- The Old Fashion of Oracle Performance Optimization
- Why Are Cache-Hit Ratios Grossly Inefficient?
- The New Fashion of Oracle Performance Optimization
- The OWI Philosophy
- Database Response Time Tuning Model
- Paradigm Shift
- In a Nutshell
- Chapter 2: Oracle Wait Interface Components
- OWI Components
- New OWI Views in Oracle Database 10g Release 1
- OWI Limitations
- In a Nutshell
- Chapter 3: Common Wait Events
- Common Wait Events in Oracle Real Application Clusters Environment
- Tracking CPU and Other Statistics
- In a Nutshell
- Chapter 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 PLSQL Procedure
- Sampling for Performance Data with SQL-less SGA Access
- In a Nutshell
- Chapter 5: Interpreting Common IO Related Wait Events
- db file sequential read
- db file scattered read
- direct path read
- direct path write
- db file parallel write
- log file parallel write
- control file parallel write
- In a Nutshell
- Chapter 6: Interpreting Locks-Related Wait Events
- Latch Free
- Enqueue
- Buffer Busy Waits
- In a Nutshell
- Chapter 7: Interpreting Common Latency-Related Wait Events
- log buffer space
- free buffer waits
- write complete waits
- log file switch completion
- log file switch (checkpoint incomplete)
- In a Nutshell
- Chapter 8: Wait Events in a Real Application Clusters Environment
- Global Cache Waits
- RAC Wait Event Enhancements in Oracle Database 10g
- Enqueue Waits
- In a Nutshell
- Chapter 9: Performance Management in Oracle Database 10g
- New Background Processes
- Automatic Workload Repository
- Active Session History
- Automatic Database Diagnostic Monitor (ADDM)
- In a Nutshell
- Appendix A: Oracle Database 10g Diagnostic Events
- Appendix B: Enqueue Waits in Oracle Database 10g
- Appendix C: Oracle Dumps and Traces
- Data Block Dump
- Buffers Dump
- Buffer Dump
- File Headers Dump
- Control File Dump
- Heap Dump
- Library Cache Dump
- Processstate Dump
- Shared Server State Dump
- Systemstate Dump
- Redo Log Dump
- Appendix D: Direct SGA Access
- Security
- 1
- 2
Similar products
Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition (Oracle Press)
Oracle Database 11g Release 2 Performance Tuning Tips & Techniques (Oracle Press)
Oracle Database 10g Performance Tuning Tips & Techniques (Oracle Press)
Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions