---

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)

ISBN: 007222729X
EAN: 2147483647

Year: 2004
Pages: 114

Authors: Richmond Shee, Kirtikumar Deshpande, K. Gopalakrishnan

BUY ON AMAZON

• 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