Optimizing Oracle performance
(eBook)
Author
Contributors
Published
Sebastopol, CA ; Farnham : O'Reilly, 2003.
Format
eBook
Edition
1st ed.
ISBN
059600527X, 059651719X, 1449366783, 9780596005276, 9780596517199, 9781449366780
Physical Desc
1 online resource (xxv, 388 pages) : illustrations
Status
Description
Loading Description...
Also in this Series
Checking series information...
More Details
Language
English
UPC
059600527X
Notes
General Note
"A practitioner's guide to optimizing response time"--Cover
Bibliography
Includes bibliographical references (pages 374-380) and index.
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 explai.
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation, 7th Edition (style guide)
Millsap, C. V., & Holt, J. (2003). Optimizing Oracle performance . O'Reilly.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Millsap, Cary V and Jeff. Holt. 2003. Optimizing Oracle Performance. O'Reilly.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Millsap, Cary V and Jeff. Holt. Optimizing Oracle Performance O'Reilly, 2003.
MLA Citation, 9th Edition (style guide)Millsap, Cary V., and Jeff Holt. Optimizing Oracle Performance O'Reilly, 2003.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.
Staff View
Grouped Work ID
20973427-60ab-c9d2-1a5c-7bfe1b37dda0-eng
Grouping Information
| Grouped Work ID | 20973427-60ab-c9d2-1a5c-7bfe1b37dda0-eng |
|---|---|
| Full title | optimizing oracle performance |
| Author | millsap cary v |
| Grouping Category | book |
| Last Update | 2024-10-04 13:10:14PM |
| Last Indexed | 2024-10-12 03:38:11AM |
Book Cover Information
| Image Source | syndetics |
|---|---|
| First Loaded | Oct 4, 2024 |
| Last Used | Oct 6, 2024 |
Marc Record
| First Detected | Jul 29, 2024 03:56:06 PM |
|---|---|
| Last File Modification Time | Oct 04, 2024 01:10:40 PM |
MARC Record
| LEADER | 06584cam a2200613 a 4500 | ||
|---|---|---|---|
| 001 | ocm55504560 | ||
| 003 | OCoLC | ||
| 005 | 20240927105016.0 | ||
| 006 | m o d | ||
| 007 | cr cn||||||||| | ||
| 008 | 040528s2003 caua obf 001 0 eng d | ||
| 015 | |a GBA3X4246|2 bnb | ||
| 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 059651719X|q (electronic bk.) | ||
| 020 | |a 1449366783 | ||
| 020 | |a 9780596005276|q (Online version) | ||
| 020 | |a 9780596517199|q (electronic bk.) | ||
| 020 | |a 9781449366780 | ||
| 024 | 8 | |a 059600527X | |
| 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 | ||
| 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|d OCLCQ|d OCLCO|d OCLCL | ||
| 049 | |a FMGA | ||
| 050 | 4 | |a QA76.9.D3|b M577 2003 | |
| 082 | 0 | 4 | |a 005.75/85|2 22 |
| 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 | ||
| 500 | |a "A practitioner's guide to optimizing response time"--Cover | ||
| 504 | |a Includes bibliographical references (pages 374-380) and index. | ||
| 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 | |
| 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. | ||
| 588 | 0 | |a Print version record. | |
| 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. | |
| 700 | 1 | |a Holt, Jeff. | |
| 758 | |i has work:|a Optimizing Oracle performance (Work)|1 https://id.oclc.org/worldcat/entity/E39PCYt8GkFMJQvRdtmTbcFGwP|4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 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://www.aclib.us/OReilly |