Optimizing Oracle Performance
Home > Computing and Information Technology > Databases > Database software > Optimizing Oracle Performance: (O'Reilly Ser.)
Optimizing Oracle Performance: (O'Reilly Ser.)

Optimizing Oracle Performance: (O'Reilly Ser.)

|
     0     
5
4
3
2
1




International Edition


About the Book

This text dispenses with database-centric metrics and instead shows how to use Oracle's response time statistics to diagnose performance problems in an Oracle application system. Former VP of Oracle's System Performance Group, Cary Millsap, clearly shows how eliminating requests for unneeded work improves performance dramatically. He also shows how the mathematical discipline of queueing theory can be combined with response time metrics to accurately predict the impact of system changes and upgrades. This text clearly and concisely explains how to use Oracle's response time statistics to diagnose and repair performance problems. It also shows how "queueing theory" can be applied to response time statistics to predict the impact of upgrades and other system changes. The book aims to eliminate 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. It also intends to cut a path through the complexity of current tuning methods, and streamline 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.

Table of Contents:
Part I. Method 1. A Better Way to Optimize "You're Doing It Wrong" Requirements of a Good Method Three Impor tant 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 Res ponse 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. Deployment10. 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.


Best Sellers


Product Details
  • ISBN-13: 9780596005276
  • Publisher: O'Reilly Media
  • Publisher Imprint: O'Reilly Media
  • Height: 238 mm
  • No of Pages: 390
  • Returnable: 00
  • Spine Width: 25 mm
  • ISBN-10: 059600527X
  • Publisher Date: 21 Oct 2003
  • Binding: Paperback
  • Language: English
  • Returnable: Y
  • Series Title: O'Reilly Ser.
  • Width: 172 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Optimizing Oracle Performance: (O'Reilly Ser.)
O'Reilly Media -
Optimizing Oracle Performance: (O'Reilly Ser.)
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Optimizing Oracle Performance: (O'Reilly Ser.)

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!