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
Qshell for iSeries
Running Qshell
Using Parameters and Variables
Command-Line Arguments
Sed
Appendix C Qshell and CL Commands for the IFS
Certified Ethical Hacker Exam Prep
Summary
Apply Your Knowledge
Summary
Study Strategies
Title
Competency-Based Human Resource Management
An Overview of Competency-Based HR Management Practices
A Need for Implementing Competency-Based HR Management
Competency-Based Employee Recruitment and Selection
Competency-Based Performance Management
Appendix C Examples of Life-Career Assessment Exercises
Twisted Network Programming Essentials
Adding Twisted Utilities to Your Path
Web Services and RPC
Using the REST Architecture for Web Services
Enabling Web Services Using XML-RPC
Running a Twisted Application as a Daemon
InDesign Type: Professional Typography with Adobe InDesign CS2
Up Next
Contextual Alternates
Stylistic Sets
Tricks with Drop Caps
Shaping Text Frames
Sap Bw: a Step By Step Guide for Bw 2.0
Creating an InfoCube
Multi-Cubes
Data Maintenance
Summary
Object Transport
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