Optimizing Oracle Performance

ISBN-10: 059600527X

ISBN-13: 9780596005276

Edition: 2003

List price: $39.99 Buy it from $3.00
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

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, andwait 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.
New Starting from $30.04
eBooks Starting from $33.99
Rent eBooks
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Sociology Online content $4.95 $1.99
Add to cart
Study Briefs
Business Ethics Online content $4.95 $1.99
Add to cart
Study Briefs
Business Law Online content $4.95 $1.99
Customers also bought
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $39.99
Copyright year: 2003
Publisher: O'Reilly Media, Incorporated
Publication date: 9/26/2003
Binding: Paperback
Pages: 418
Size: 6.75" wide x 9.00" long x 1.00" tall
Weight: 1.430
Language: English

Foreword
Preface
Method
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
Targeting the Right User Actions
Specification Reliability
Making a Good Specification
Specification Over-Constraint
Targeting the Right Diagnostic Data
Expectations About Data Collection
Data Scope
Oracle Diagnostic Data Sources
For More Information
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
Reference
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
Collecting Extended SQL Trace Data
Understanding Your Application
Activating Extended SQL Trace
Finding Your Trace File(s)
Eliminating Collection Error
Exercises
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
Oracle Fixed View Data
Deficiencies of Fixed View Data
Fixed View Reference
Useful Fixed View Queries
The Oracle "Wait Interface"
Exercises
Queueing Theory for the Oracle Practitioner
Performance Models
Queueing
Queueing Theory
The M/M/m Queueing Model
Perspective
Exercises
Deployment
Working the Resource Profile
How to Work a Resource Profile
How to Forecast Improvement
How to Tell When Your Work Is Done
Responding to the Diagnosis
Beyond the Resource Profile
Response Time Components
Eliminating Wasteful Work
Attributes of a Scalable Application
Case Studies
Misled by System-Wide Data
Large CPU Service Duration
Large SQL *Net Event Duration
Large Read Event Duration
Conclusion
Appendixes
Glossary
Greek Alphabet
Optimizing Your Database Buffer Cache Hit Ratio
M/M/m Queueing Theory Formulas
References
Index
×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×