Optimizing Oracle Performance

Valutazione media 3,92
( su 26 valutazioni fornite da GoodReads )
 
9780596005276: Optimizing Oracle Performance

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.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

L'autore:

Cary Millsap is the former Vice President of Oracle's System Performance Group and the cofounder of Hotsos, a company dedicated to Oracle system performance. Hotsos provides performance-improvement tools for Oracle environments and also delivers training in the form of clinics and symposiums. Cary is also a founding member of the Oak Table Network (http://www.oaktable.net), an informal association of "Oracle Scientists" well known throughout the Oracle community.

Jeff Holt is one of the world's most productive Oracle performance optimization specialists. He has tremendous experience in constructing training programs and software tools to optimize the system performance management process. He is a former support analyst and consultant at Oracle Corporation, where he served as a technology leader in the System Performance Group. He is the Hotsos Tools lead designer and developer, the author of several technical papers, a Hotsos founding employee, and a Hotsos Clinic principal developer.

Contenuti:

Dedication; Foreword; Preface; Why I Wrote This Book; Audience for This Book; Structure of This Book; Which Platform and Version?; What This Book Is and Is Not; About the Tools, Examples, and Exercises; Citations; Conventions Used in This Book; Comments and Questions; Acknowledgments; Part I: Method; Chapter 1: A Better Way to Optimize; 1.1 “You’re Doing It Wrong”; 1.2 Requirements of a Good Method; 1.3 Three Important Advances; 1.4 Tools for Analyzing Response Time; 1.5 Method R; Chapter 2: Targeting the Right User Actions; 2.1 Specification Reliability; 2.2 Making a Good Specification; 2.3 Specification Over-Constraint; Chapter 3: Targeting the Right Diagnostic Data; 3.1 Expectations About Data Collection; 3.2 Data Scope; 3.3 Oracle Diagnostic Data Sources; 3.4 For More Information; Chapter 4: Targeting the Right Improvement Activity; 4.1 A New Standard of Customer Care; 4.2 How to Find the Economically Optimal Performance Improvement Activity; 4.3 Making Sense of Your Diagnostic Data; 4.4 Forecasting Project Net Payoff; Part II: Reference; Chapter 5: Interpreting Extended SQL Trace Data; 5.1 Trace File Walk-Through; 5.2 Extended SQL Trace Data Reference; 5.3 Response Time Accounting; 5.4 Evolution of the Response Time Model; 5.5 Walking the Clock; 5.6 Forward Attribution; 5.7 Detailed Trace File Walk-Through; 5.8 Exercises; Chapter 6: Collecting Extended SQL Trace Data; 6.1 Understanding Your Application; 6.2 Activating Extended SQL Trace; 6.3 Finding Your Trace File(s); 6.4 Eliminating Collection Error; 6.5 Exercises; Chapter 7: Oracle Kernel Timings; 7.1 Operating System Process Management; 7.2 Oracle Kernel Timings; 7.3 How Software Measures Itself; 7.4 Unaccounted-for Time; 7.5 Measurement Intrusion Effect; 7.6 CPU Consumption Double-Counting; 7.7 Quantization Error; 7.8 Time Spent Not Executing; 7.9 Un-Instrumented Oracle Kernel Code; 7.10 Exercises; Chapter 8: Oracle Fixed View Data; 8.1 Deficiencies of Fixed View Data; 8.2 Fixed View Reference; 8.3 Useful Fixed View Queries; 8.4 The Oracle “Wait Interface”; 8.5 Exercises; Chapter 9: Queueing Theory for the Oracle Practitioner; 9.1 Performance Models; 9.2 Queueing; 9.3 Queueing Theory; 9.4 The M/M/m Queueing Model; 9.5 Perspective; 9.6 Exercises; Part III: Deployment; Chapter 10: Working the Resource Profile; 10.1 How to Work a Resource Profile; 10.2 How to Forecast Improvement; 10.3 How to Tell When Your Work Is Done; Chapter 11: Responding to the Diagnosis; 11.1 Beyond the Resource Profile; 11.2 Response Time Components; 11.3 Eliminating Wasteful Work; 11.4 Attributes of a Scalable Application; Chapter 12: Case Studies; 12.1 Case 1: Misled by System-Wide Data; 12.2 Case 2: Large CPU Service Duration; 12.3 Case 3: Large SQL*Net Event Duration; 12.4 Case 4: Large Read Event Duration; 12.5 Conclusion; Part IV: Appendixes; Appendix A: Greek Alphabet; Appendix B: Optimizing Your Database Buffer Cache Hit Ratio; Appendix C: M/M/m Queueing Theory Formulas; Appendix D: References; Colophon;

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

I migliori risultati di ricerca su AbeBooks

1.

Millsap, Cary V.;Holt, Jeff
Editore: Oreilly & Associates Inc, Chambersburg, Pennsylvania, U.S.A. (2003)
ISBN 10: 059600527X ISBN 13: 9780596005276
Nuovi Soft cover Quantità: 2
Da
SottoVoceBooks
(Garland, TX, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Oreilly & Associates Inc, Chambersburg, Pennsylvania, U.S.A., 2003. Soft cover. Condizione libro: New. NEW Book, cover/text completely pristine-free of any wear. Has cosmetic remainder mark on bottom. FREE TRACKING within the US, and email notice when shipped. Normally, books are shipped twice a day, with afternoon USPS pickup, or next morning drop-off at the Post Office. We package on Sunday for shipment first thing Monday morning. Your satisfaction guaranteed. We have multiple copies of most books. Email inquiries are welcomed. Thanks for reading all of our boilerplate ;-). Codice libro della libreria 007165

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 12,86
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,66
In U.S.A.
Destinazione, tempi e costi

2.

Millsap, Cary; Holt, Jeff
Editore: O'Reilly Media
ISBN 10: 059600527X ISBN 13: 9780596005276
Nuovi PAPERBACK Quantità: > 20
Da
Mediaoutlet12345
(Springfield, VA, U.S.A.)
Valutazione libreria
[?]

Descrizione libro O'Reilly Media. PAPERBACK. Condizione libro: New. 059600527X *BRAND NEW* Ships Same Day or Next!. Codice libro della libreria SWATI2122347998

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 19,64
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,69
In U.S.A.
Destinazione, tempi e costi

3.

Millsap, Cary; Holt, Jeff
Editore: O'Reilly Media (2003)
ISBN 10: 059600527X ISBN 13: 9780596005276
Nuovi Paperback Quantità: 1
Da
Irish Booksellers
(Rumford, ME, U.S.A.)
Valutazione libreria
[?]

Descrizione libro O'Reilly Media, 2003. Paperback. Condizione libro: New. book. Codice libro della libreria 059600527X

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 23,49
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
In U.S.A.
Destinazione, tempi e costi

4.

Millsap, Cary
ISBN 10: 059600527X ISBN 13: 9780596005276
Nuovi Paperback Quantità: > 20
Print on Demand
Da
BargainBookStores
(Grand Rapids, MI, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Paperback. Condizione libro: New. This item is printed on demand. Item doesn't include CD/DVD. Codice libro della libreria 1517875

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 20,53
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,69
In U.S.A.
Destinazione, tempi e costi

5.

Cary Millsap, Jeff Holt
Editore: O'Reilly Media (2003)
ISBN 10: 059600527X ISBN 13: 9780596005276
Nuovi Paperback Quantità: 1
Da
Ergodebooks
(RICHMOND, TX, U.S.A.)
Valutazione libreria
[?]

Descrizione libro O'Reilly Media, 2003. Paperback. Condizione libro: New. Codice libro della libreria DADAX059600527X

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 24,02
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,69
In U.S.A.
Destinazione, tempi e costi

6.

Cary V. Millsap, Jeff Holt
Editore: O Reilly Media, Inc, USA, United States (2003)
ISBN 10: 059600527X ISBN 13: 9780596005276
Nuovi Paperback Quantità: 1
Da
The Book Depository US
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro O Reilly Media, Inc, USA, United States, 2003. Paperback. Condizione libro: New. 232 x 178 mm. Language: English . Brand New 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. Codice libro della libreria AAH9780596005276

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 27,79
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

7.

Cary V. Millsap, Jeff Holt
Editore: O Reilly Media, Inc, USA, United States (2003)
ISBN 10: 059600527X ISBN 13: 9780596005276
Nuovi Paperback Quantità: 1
Da
The Book Depository
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro O Reilly Media, Inc, USA, United States, 2003. Paperback. Condizione libro: New. 232 x 178 mm. Language: English . Brand New 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. Codice libro della libreria AAH9780596005276

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 29,74
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

8.

Millsap, Cary
Editore: O'Reilly Media (2017)
ISBN 10: 059600527X ISBN 13: 9780596005276
Nuovi Paperback Quantità: 20
Print on Demand
Da
Murray Media
(North Miami Beach, FL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro O'Reilly Media, 2017. Paperback. Condizione libro: New. This item is printed on demand. Codice libro della libreria 059600527X

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 27,39
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 2,77
In U.S.A.
Destinazione, tempi e costi

9.

Cary Millsap
Editore: O'Reilly Media 2003-09-23 (2003)
ISBN 10: 059600527X ISBN 13: 9780596005276
Nuovi Quantità: 5
Da
Chiron Media
(Wallingford, Regno Unito)
Valutazione libreria
[?]

Descrizione libro O'Reilly Media 2003-09-23, 2003. Condizione libro: New. Brand new book, sourced directly from publisher. Dispatch time is 24-48 hours from our warehouse. Book will be sent in robust, secure packaging to ensure it reaches you securely. Codice libro della libreria NU-ING-00311221

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 26,80
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,45
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

10.

Cary Millsap
ISBN 10: 059600527X ISBN 13: 9780596005276
Nuovi Paperback Quantità: 1
Da
Grand Eagle Retail
(Wilmington, DE, U.S.A.)
Valutazione libreria
[?]

Descrizione libro 2003. Paperback. Condizione libro: New. 172mm x 25mm x 238mm. Paperback. 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.Shipping may be from multiple locations in the US or from the UK, depending on stock availability. 388 pages. 0.640. Codice libro della libreria 9780596005276

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 31,77
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
In U.S.A.
Destinazione, tempi e costi

Vedi altre copie di questo libro

Vedi tutti i risultati per questo libro