Flylib.com
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
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
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
Agile Project Management: Creating Innovative Products (2nd Edition)
Project Size
Practice: Participant Identification
Envision Summary
Practice: Workload Management
Practice: Daily Team Integration Meetings
CISSP Exam Cram 2
APPLICATION AND SYSTEMS-DEVELOPMENT SECURITY
LAW, INVESTIGATIONS, AND ETHICS
Contingency Planning, Backup, and Recovery
Cryptographic Services
Answers to Exam Prep Questions
Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain
Retail Logistics: Changes and Challenges
Fashion Logistics and Quick Response
Logistics in Tesco: Past, Present and Future
Temperature-Controlled Supply Chains
The Development of E-tail Logistics
Special Edition Using Crystal Reports 10
Working with the Sort Expert
Introduction
Introduction
Crystal Enterprise User Launchpad
Crystal Enterprise Viewing Reports
After Effects and Photoshop: Animation and Production Effects for DV and Film, Second Edition
Basic ImageReady Animation, Tweening, and Layer Styles
Photoshop Layers and After Effects
Matte and Keying Plug-ins
Color, Light, and Focus
Appendix Adobe Photoshop and After Effects Resources
Comparing, Designing, and Deploying VPNs
A Detailed Examination of MPLS Layer 3 VPNs
Designing QoS for IPsec VPNs
Review Questions
Designing and Implementing L2TPv2 and L2TPv3 Remote Access VPNs
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies