Oracle Wait Interface A Practical Guide to Performance Diagnostics & Tuning
10墨值下载
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning
by Richmond Shee, Kirtikumar Deshpande and K Gopalakrishnan
ISBN:007222729x
McGraw-Hill/Osborne © 2004 (350 pages)
This book explains how to take full advantage of the revolutionary Oracle Wait Interface to
quickly pinpoint--and solve--core problems and bottlenecks, and increase productivity
exponentially.
Table of Contents
Oracle Wait Interface—A Practical Guide to Performance Diagnostics & Tuning
Foreword
Introduction
Chapter 1 -Introduction to Oracle Wait Interface
Chapter 2 -Oracle Wait Interface Components
Chapter 3 -Common Wait Events
Chapter 4 -OWI Monitoring and Collection Methods
Chapter 5 -Interpreting Common I/O Related Wait Events
Chapter 6 -Interpreting Locks-Related Wait Events
Chapter 7 -Interpreting Common Latency-Related Wait Events
Chapter 8 -Wait Events in a Real Application Clusters Environment
Chapter 9 -Performance Management in Oracle Database 10g
Appendix A -Oracle Database 10 g Diagnostic Events
Appendix B -Enqueue Waits in Oracle Database 10g
Appendix C -Oracle Dumps and Traces
Appendix D -Direct SGA Access
Appendix E -References
Index
List of Figures
List of Tables
List of Sidebars
1/1
2006-11-2mk:@MSITStore:E:\MyDocs\Oracle\ChmBooks\Wait.Interface.A.Practical....
Chapter 1: Introduction to Oracle Wait
Interface
Overview
Speed is the word that defines the twenty-first century. The previous century’s saying, “He who dies
with the most toys wins” is now “He who dies with the most high-speed toys wins.” We want speed
in everything we do, be it in our personal lives or the business we conduct. You name it—fast cars,
fast computers, fast lanes, fast Internet connections, fast weight loss, fast cures, fast food, and so on.
Businesses compete with one another to be the first to introduce new products to the marketplace.
The speed-to-
market demand overrides the conventional process of software engineering that used to
include such concepts as application analysis, design, code development, test, and implementation.
Nowadays, programmers start coding before the requirements are established. And the requirements
keep changing throughout the development lifecycle. Furthermore, the testing phase often is
shortened or sacrificed to meet unrealistic production dates. Needless to say, many untested
applications interact with production databases for the first time on the release day.
In tandem with today’s fast-paced world, database sizes have increased as businesses have found
value in keeping historical data longer, sometimes “forever,” for various analyses to gain a
competitive edge. Databases that do not scale well often result in higher processing time in spite of
the availability of better and more reliable hardware.
These issues eventually flow downstream and quite often are relabeled as “database performance”
problems. Unfortunately, database administrators (DBAs) have to deal with this on a regular basis
and take the blame. Corporate IT organizations expect DBAs to possess the required know-how and
be available 24x7 for speedy resolution of all performance problems. Due to this, performance
monitoring and optimization functions have gained prominence and consume most of a DBA’s time.
DBAs need reliable performance monitoring and tuning methods. Oracle fulfilled this requirement
by architecting the Oracle Wait Interface (OWI) to help DBAs quickly and effectively diagnose
performance problems.
This book is all about the Oracle Wait Interface. It gives DBAs a detailed working knowledge of
how to use OWI and a practical approach to performance diagnostics and troubleshooting that is
based on real experience with large and complex database installations. DBAs will gain an in-depth
knowledge of the OWI methodology and will be able to apply the knowledge to solve performance
issues.
In this chapter, we compare the OWI with the ratio-based methodology that is still practiced by
many DBAs. We outline the limitations of the ratio-based method and highlight the advantages of
OWI, thus establishing it as the methodology of choice. It is our sincere hope that this book will
assist DBAs in transitioning to using OWI as the main Oracle performance optimization
methodology.
The Old Fashion of Oracle Performance Optimization
1/9
2006-11-2file://C:\Documents and Settings\qiuyb\Local Settings\Temp\~hh311A.htm
of 242
10墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论