Home   FAQs   New Arrivals   Specials   Pricing & Shipping   Location   Corporate Services   Why Choose Bookware?  
 Search:   
Call our store: 9955 5567 (from within Sydney) or 1800 734 567 (from outside Sydney)
 View Cart   Check Out   
 
Browse by Subject
 TAFE Accounting
 TAFE I.T./Computing
 TAFE - Other
I.T
 .NET
 Windows 8
 Adobe CS6
 Cisco
 CCNA 2012
 CCNP 2012
 Java
 VB
 ASP
 Web Design
 E-Commerce
 Project Management
 ITIL
 Macintosh
 Mobile Devices
 Linux
 Windows Server 2012
 SQL Server 2012
 SAP
Certification
 MCITP
 MCTS
Economics and Business
 Accounting
 Business Information Systems
 Economics
 Finance
 Management
 Marketing
 TAX
 Human Resources
Academic
 Law
 Nursing
 Medical
 Psychology
 Engineering

Optimizing Oracle Performance

by: Cary Millsap

On-line Price: $19.95 (includes GST)

Paperback package 304

65%Off Retail Price

You save: $38.00

CLEARANCE Item - Special discount -limited stock
_____________________
N.Sydney : In Stock

Retail Price: $57.95

Publisher: O'REILLY,30.09.03

Category: ORACLE Level: B/I/A

ISBN: 059600527X
ISBN13: 9780596005276

Add to Shopping Cart

Oracle DBAs and developers are all too familiar with the outlay of time and resources, blown budgets, missed deadlines, and marginally effective performance fiddling that is commonplace with traditional methods of Oracle performance tuning. In Optimizing Oracle Performance, Cary Millsap, former VP of Oracle's System Performance Group, clearly and concisely explains how to use Oracle's response time statistics to diagnose and repair performance problems. Cary also shows how 'queueing theory' can be applied to response time statistics to predict the impact of upgrades and other system changes. The price of this essential book will be paid back in hours saved the first time its methods are used.


      Full Description

Oracle system performance inefficiencies often go undetected for months or even years--even under intense scrutiny--because traditional Oracle performance analysis methods and tools are fundamentally flawed. They're unreliable and inefficient.


  Oracle DBAs and developers are all too familiar with the outlay of time and resources, blown budgets, missed deadlines, and marginally effective performance fiddling that is commonplace with traditional methods of Oracle performance tuning. In this crucial book, Cary Millsap, former VP of Oracle's System Performance Group, clearly and concisely explains how to use Oracle's response time statistics to diagnose and repair performance problems. Cary also shows how 'queueing theory' can be applied to response time statistics to predict the impact of upgrades and other system changes.


  Optimizing Oracle Performance eliminates the time-consuming, trial-and-error guesswork inherent in most conventional approaches to tuning. You can determine exactly where a system's performance problem is, and with equal importance, where it is not, in just a few minutes--even if the problem is several years old.


  Optimizing Oracle Performance cuts a path through the complexity of current tuning methods, and streamlines an approach that focuses on optimization techniques that any DBA can use quickly and successfully to make noticeable--even dramatic--improvements.


  For example, the one thing database users care most about is response time. Naturally, DBAs focus much of their time and effort towards improving response time. But it is entirely too easy to spend hundreds of hours to improve important system metrics such as hit ratios, average latencies, and wait times, only to find users are unable to perceive the difference. And an expensive hardware upgrade may not help either.


  It doesn't have to be that way. Technological advances have added impact, efficiency, measurability, predictive capacity, reliability, speed, and practicality to the science of Oracle performance optimization. Optimizing Oracle Performance shows you how to slash the frustration and expense associated with unraveling the true root cause of any type of performance problem, and reliably predict future performance.


  The price of this essential book will be paid back in hours saved the first time its methods are used.


      

Table of Contents

Foreword


  Preface


        Part I. Method


  1. A Better Way to Optimize


          'You're Doing It Wrong'


          Requirements of a Good Method


          Three Important Advances


          Tools for Analyzing Response Time


          Method R


  2. Targeting the Right User Actions


          Specification Reliability


          Making a Good Specification


          Specification Over-Constraint


  3. Targeting the Right Diagnostic Data


          Expectations About Data Collection


          Data Scope


          Oracle Diagnostic Data Sources


          For More Information


  4. Targeting the Right Improvement Activity


          A New Standard of Customer Care


          How to Find the Economically Optimal Performance Improvement Activity


          Making Sense of Your Diagnostic Data


          Forecasting Project Net Payoff


        Part II. Reference


  5. Interpreting Extended SQL Trace Data


          Trace File Walk-Through


          Extended SQL Trace Data Reference


          Response Time Accounting


          Evolution of the Response Time Model


          Walking the Clock


          Forward Attribution


          Detailed Trace File Walk-Through


          Exercises


  6. Collecting Extended SQL Trace Data


          Understanding Your Application


          Activating Extended SQL Trace


          Finding Your Trace File(s)


          Eliminating Collection Error


          Exercises


  7. Oracle Kernel Timings


          Operating System Process Management


          Oracle Kernel Timings


          How Software Measures Itself


          Unaccounted-for Time


          Measurement Intrusion Effect


          CPU Consumption Double-Counting


          Quantization Error


          Time Spent Not Executing


          Un-Instrumented Oracle Kernel Code


          Exercises


  8. Oracle Fixed View Data


          Deficiencies of Fixed View Data


          Fixed View Reference


          Useful Fixed View Queries


          The Oracle 'Wait Interface'


          Exercises


  9. Queueing Theory for the Oracle Practitioner


          Performance Models


          Queueing


          Queueing Theory


          The M/M/m Queueing Model


          Perspective


          Exercises


        Part III. Deployment

10. Working the Resource Profile


          How to Work a Resource Profile


          How to Forecast Improvement


          How to Tell When Your Work Is Done


  11. Responding to the Diagnosis


          Beyond the Resource Profile


          Response Time Components


          Eliminating Wasteful Work


          Attributes of a Scalable Application


  12. Case Studies


          Case 1: Misled by System-Wide Data


          Case 2: Large CPU Service Duration


          Case 3: Large SQL*Net Event Duration


          Case 4: Large Read Event Duration


          Conclusion


        Part IV. Appendixes


  A. Glossary


  B. Greek Alphabet


  C. Optimizing Your Database Buffer Cache Hit Ratio


  D. M/M/m Queueing Theory Formulas


  E. References


      Index