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
ERP and Data Warehousing in Organizations: Issues and Challenges
Challenging the Unpredictable: Changeable Order Management Systems
The Second Wave ERP Market: An Australian Viewpoint
The Effects of an Enterprise Resource Planning System (ERP) Implementation on Job Characteristics – A Study using the Hackman and Oldham Job Characteristics Model
Context Management of ERP Processes in Virtual Communities
Development of Interactive Web Sites to Enhance Police/Community Relations
A Practitioners Guide to Software Test Design
Case Studies
Section I - Black Box Testing Techniques
Equivalence Class Testing
Scripted Testing
Section V - Some Final Thoughts
Systematic Software Testing (Artech House Computer Library)
Risk Analysis
Test Implementation
The Software Tester
Improving the Testing Process
Appendix F Process Diagrams
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
What Is SQL*Plus?
The SQL Buffer
Table Constraints
Branching in SQL*Plus
Looping in SQL*Plus
Special Edition Using FileMaker 8
Advanced Scripting Techniques
Script Parameters and Script Results
FileMaker Extra: Portals and Record Locking
Importing from an XML Data Source
Peer-to-Peer Hosting
Comparing, Designing, and Deploying VPNs
A Detailed Examination of MPLS Layer 3 VPNs
Summary
Deploying IPsec VPNs: Fundamental Considerations
Review Questions
Deploying SSL VPNs (WebVPN) on the ASA 5500
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