Cargando…
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 wit...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, CA ; Farnham :
O'Reilly,
2003.
|
| Edición: | 1st ed. |
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000Ia 4500 | ||
|---|---|---|---|
| 001 | OR_ocm55504560 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cn||||||||| | ||
| 008 | 040528s2003 caua obf 001 0 eng d | ||
| 010 | |a 2004272336 | ||
| 040 | |a BUF |b eng |e pn |c BUF |d OCLCQ |d BAKER |d OCLCQ |d LVB |d UMC |d CEF |d OCLCQ |d CUSER |d OCLCQ |d OCLCF |d IDEBK |d N$T |d EBLCP |d MHW |d DEBSZ |d OCLCO |d YDXCP |d OCLCQ |d GO9 |d E7B |d OCL |d OCLCQ |d COO |d FEM |d OCLCQ |d UIU |d MOQ |d AU@ |d OCLCO |d WYU |d OCLCQ |d OCLCO |d VT2 |d RDF |d UHL |d UKAHL |d OCLCQ |d INARC |d OCLCO |d OCLCQ |d OCLCO | ||
| 015 | |a GBA3-X4246 | ||
| 019 | |a 326736247 |a 770008755 |a 809686510 |a 861530701 |a 966075241 |a 968076411 |a 968985939 |a 1019733028 |a 1044294780 |a 1056391184 |a 1060864211 |a 1064907309 |a 1075560355 |a 1103252765 |a 1113790278 |a 1129368214 |a 1194909817 |a 1202552575 |a 1240510396 | ||
| 020 | |a 059600527X |q (Online version) | ||
| 020 | |a 9780596005276 |q (Online version) | ||
| 020 | |a 9780596517199 |q (electronic bk.) | ||
| 020 | |a 059651719X |q (electronic bk.) | ||
| 020 | |a 9781449366780 | ||
| 020 | |a 1449366783 | ||
| 024 | 8 | |a 059600527X | |
| 029 | 1 | |a DEBSZ |b 396386644 | |
| 029 | 1 | |a AU@ |b 000066233576 | |
| 035 | |a (OCoLC)55504560 |z (OCoLC)326736247 |z (OCoLC)770008755 |z (OCoLC)809686510 |z (OCoLC)861530701 |z (OCoLC)966075241 |z (OCoLC)968076411 |z (OCoLC)968985939 |z (OCoLC)1019733028 |z (OCoLC)1044294780 |z (OCoLC)1056391184 |z (OCoLC)1060864211 |z (OCoLC)1064907309 |z (OCoLC)1075560355 |z (OCoLC)1103252765 |z (OCoLC)1113790278 |z (OCoLC)1129368214 |z (OCoLC)1194909817 |z (OCoLC)1202552575 |z (OCoLC)1240510396 | ||
| 037 | |a 7596583591716570861 |b TotalBoox |f Ebook only |n www.totalboox.com | ||
| 050 | 4 | |a QA76.9.D3 |b M577 2003 | |
| 072 | 7 | |a COM |x 018000 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.75/85 |2 22 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Millsap, Cary V. | |
| 245 | 1 | 0 | |a Optimizing Oracle performance / |c Cary Millsap with Jeff Holt. |
| 250 | |a 1st ed. | ||
| 260 | |a Sebastopol, CA ; |a Farnham : |b O'Reilly, |c 2003. | ||
| 300 | |a 1 online resource (xxv, 388 pages) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file |2 rda | ||
| 500 | |a "A practitioner's guide to optimizing response time"--Cover. | ||
| 504 | |a Includes bibliographical references (pages 374-380) and index. | ||
| 588 | 0 | |a Print version record. | |
| 520 | |a 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 explai. | ||
| 542 | |f Copyright © O'Reilly Media, Inc. |g 2003. | ||
| 505 | 0 | |a Table of Contents; 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; A Better Way to Optimize; "You're Doing It Wrong"; Requirements of a Good Method; Three Important Advances; User Action Focus; Response Time Focus; Amdahl's Law; All Together Now; Tools for Analyzing Response Time; Sequence Diagram; Resource Profile; MethodR; Who Uses the Method | |
| 505 | 8 | |a The abominable smokestackThe optimal performance analyst; Your role; Overcoming Common Objections; "But my whole system is slow"; "The method only works if the problem is the database"; "The method is unconventional"; Evaluation of Effectiveness; Targeting the Right User Actions; Specification Reliability; The System; Economic Constraints; Making a Good Specification; User Action; Identifying the Right User Actions and Contexts; Prioritizing the User Actions; Determining Who Will Execute Each Action and When; Specification Over-Constraint; Targeting the Right Diagnostic Data | |
| 505 | 8 | |a Expectations About Data CollectionData Scope; Scoping Errors; Long-Running User Actions; "Too Much Data" Is Really Not Enough Data; Oracle Diagnostic Data Sources; For More Information; Targeting the Right ImprovementActivity; 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; Forecasting Project Benefits; Monetizing the benefits; If you can't monetize the benefits; Forecasting Project Cost; Forecasting Project Risk; Part II; Interpreting Extended SQL Trace Data | |
| 505 | 8 | |a Trace File Walk-ThroughExtended SQL Trace Data Reference; Trace File Element Definitions; Cursor numbers; Session identification and timestamps; Application identification; Cursor identification; Database calls; Wait events; Bind variables; Row source operations; Transaction end markers; Reference summary; Oracle Time Units; Response Time Accounting; Time Within a Database Call; Time Between Database Calls; Recursive SQL Double-Counting; Parent-child relationships; Recursive statistics; Evolution of the Response Time Model; Walking the Clock; Oracle Release 8 and Prior; Oracle Release 9 | |
| 505 | 8 | |a Clock Walk FormulasForward Attribution; Forward Attribution for Within-Call Events; Forward Attribution for Between-Call Events; Detailed Trace File Walk-Through; Exercises; Collecting Extended SQL Trace Data; Understanding Your Application; Activating Extended SQL Trace; Tracing Your Own Source Code; Tracing Someone Else's Source Code; Triggering a session to activate its own trace; Activating trace from a third-party session; Finding Your Trace File(s); Trace File Names; Simple Client-Server Applications; Oracle Parallel Execution; Oracle Multi-Threaded Server | |
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Oracle (Computer file) |v Handbooks, manuals, etc. |
| 630 | 0 | 6 | |a Oracle (Logiciel) |v Guides, manuels, etc. |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 fast |
| 650 | 0 | |a Relational databases |v Handbooks, manuals, etc. | |
| 650 | 0 | |a SQL (Computer program language) |v Handbooks, manuals, etc. | |
| 650 | 6 | |a Bases de données relationnelles |v Guides, manuels, etc. | |
| 650 | 6 | |a SQL (Langage de programmation) |v Guides, manuels, etc. | |
| 650 | 7 | |a COMPUTERS |x Data Processing. |2 bisacsh | |
| 650 | 7 | |a Relational databases |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 655 | 7 | |a Handbooks and manuals |2 fast | |
| 700 | 1 | |a Holt, Jeff. | |
| 776 | 0 | 8 | |i Print version: |a Millsap, Cary V. |t Optimizing Oracle performance. |b 1st ed. |d Sebastopol, CA ; Farnham : O'Reilly, 2003 |w (OCoLC)52196675 |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/059600527X/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26847803 | ||
| 938 | |a Baker & Taylor |b BKTY |c 34.95 |d 26.21 |i 059600527X |n 0004254739 |s active | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL540543 | ||
| 938 | |a ebrary |b EBRY |n ebr10758581 | ||
| 938 | |a EBSCOhost |b EBSC |n 414849 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis28409188 | ||
| 938 | |a YBP Library Services |b YANK |n 7353899 | ||
| 938 | |a Internet Archive |b INAR |n optimizingoracle0000mill | ||
| 994 | |a 92 |b IZTAP | ||