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
Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems)
Introduction
Database Modeling
ORM Constraints
Generating a Physical Database Schema
Editing Logical Models”Intermediate Aspects
Project Management JumpStart
Developing Project Management Skills
Initiating the Project
Assessing Risk
Closing the Books
Appendix C Sample Project Management Checklists
Cisco Voice Gateways and Gatekeepers
Dial Plan Considerations
Case Study: Add an E1 R2 Connection to the Leeds Gateway
Analog Trunks
Case Study: Implementing a Cisco Voice Gateway at the Shanghai Office
Need for DSP Resources
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]
Chapter Two Principles
Chapter Four Precall Planning and Research
Chapter Twelve Controlling the Buying Process
Chapter Fifteen Sales Management System: Managers Managing Pipelines and Salespeople
Appendix A Value Justification Example
Wireless Hacks: Tips & Tools for Building, Extending, and Securing Your Network
Hack 22. Map Wi-Fi Networks with Kismet and GPSd
Hack 28. Scan Passively with KisMAC
Hack 78. Advertise Bonjour Services in Linux
Section B.1. Microwave Cabling
Section B.3. Antenna Guide
Visual Studio Tools for Office(c) Using C# with Excel, Word, Outlook, and InfoPath
Conclusion
Office Add-Ins
Working with the Workbooks Collection
Events in Visual Studio Tools for Office
Working with the NameSpace Object
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