Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)
ISBN: 007222729X
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 114
Pages: 114
- 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
- Speed
- Concurrency
- Get Hidden Information
- Introduction to X Views
- The Necessary Ingredients
- Attaching the SGA to a C Program
- Appendix E: References
- Index
- Index_B
- Index_C
- Index_D
- Index_E
- Index_F
- Index_G
- Index_H
- Index_I
- Index_K
- Index_L
- Index_M
- Index_N
- Index_O
- Index_P
- Index_Q
- Index_R
- Index_S
- Index_T
- Index_U
- Index_V
- Index_W
- Index_X
- Index_Y
- List of Figures
- List of Tables
- List of Sidebars
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)
ISBN: 007222729X
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 114
Pages: 114