Dynamic Oracle Performance Analytics - Roger Cornejo

Dynamic Oracle Performance Analytics (eBook)

Using Normalized Metrics to Improve Database Speed

(Autor)

eBook Download: PDF
2018 | 1st ed.
XXI, 224 Seiten
Apress (Verlag)
978-1-4842-4137-0 (ISBN)
Systemvoraussetzungen
56,99 inkl. MwSt
  • Download sofort lieferbar
  • Zahlungsarten anzeigen
Use an innovative approach that relies on big data and advanced analytical techniques to analyze and improve Oracle Database performance. The approach used in this book represents a step-change paradigm shift away from traditional methods. Instead of relying on a few hand-picked, favorite metrics, or wading through multiple specialized tables of information such as those found in an automatic workload repository (AWR) report, you will draw on all available data, applying big data methods and analytical techniques to help the performance tuner draw impactful, focused performance improvement conclusions. 

This book briefly reviews past and present practices, along with available tools, to help you recognize areas where improvements can be made. The book then guides you through a step-by-step method that can be used to take advantage of all available metrics to identify problem areas and work toward improving them. The method presented simplifies the tuning process and solves the problem of metric overload.

You will learn how to: collect and normalize data, generate deltas that are useful in performing statistical analysis, create and use a taxonomy to enhance your understanding of problem performance areas in your database and its applications, and create a root cause analysis report that enables understanding of a specific performance problem and its likely solutions. 


What You'll Learn
  • Collect and prepare metrics for analysis from a wide array of sources
  • Apply statistical techniques to select relevant metrics  
  • Create a taxonomy to provide additional insight into problem areas
  • Provide a metrics-based root cause analysis regarding the performance issue
  • Generate an actionable tuning plan prioritized according to problem areas
  • Monitor performance using database-specific normal ranges

?
Who This Book Is For

Professional tuners: responsible for maintaining the efficient operation of large-scale databases who wish to focus on analysis, who want to expand their repertoire to include a big data methodology and use metrics without being overwhelmed, who desire to provide accurate root cause analysis and avoid the cyclical fix-test cycles that are inevitable when speculation is used



?Roger Cornejo has been an Oracle enthusiast since 1985 (versions 4-12c). He has experience on large enterprise-class Oracle applications, not only in performance troubleshooting and tuning, but also in systems architecture, information modeling, and software development/project management. For the past 10 years, his main focus has been database performance analysis and tuning, with much of his time spent exploring the complexities and usefulness of AWR* tuning data. He produces Oracle Database tuning results across 12c/11g/10g (and occasionally 9i) databases. He is a thought-leader in his field, and has been recognized for his expertise in tuning. He has presented at the past eight East Coast Oracle Conferences, as well as at COLLABORATE14 and COLLABORATE18, RMOUG16, and Hotsos 2017-2018.  
Use an innovative approach that relies on big data and advanced analytical techniques to analyze and improve Oracle Database performance. The approach used in this book represents a step-change paradigm shift away from traditional methods. Instead of relying on a few hand-picked, favorite metrics, or wading through multiple specialized tables of information such as those found in an automatic workload repository (AWR) report, you will draw on all available data, applying big data methods and analytical techniques to help the performance tuner draw impactful, focused performance improvement conclusions. This book briefly reviews past and present practices, along with available tools, to help you recognize areas where improvements can be made. The book then guides you through a step-by-step method that can be used to take advantage of all available metrics to identify problem areas and work toward improving them. The method presented simplifies the tuning process and solves the problem of metric overload.You will learn how to: collect and normalize data, generate deltas that are useful in performing statistical analysis, create and use a taxonomy to enhance your understanding of problem performance areas in your database and its applications, and create a root cause analysis report that enables understanding of a specific performance problem and its likely solutions. What You'll LearnCollect and prepare metrics for analysis from a wide array of sourcesApply statistical techniques to select relevant metrics  Create a taxonomy to provide additional insight into problem areasProvide a metrics-based root cause analysis regarding the performance issueGenerate an actionable tuning plan prioritized according to problem areasMonitor performance using database-specific normal ranges?Who This Book Is ForProfessional tuners: responsible for maintaining the efficient operation of large-scale databases who wish to focus on analysis, who want to expand their repertoire to include a big data methodology and use metrics without being overwhelmed, who desire to provide accurate root cause analysis and avoid the cyclical fix-test cycles that are inevitable when speculation is used

​Roger Cornejo has been an Oracle enthusiast since 1985 (versions 4-12c). He has experience on large enterprise-class Oracle applications, not only in performance troubleshooting and tuning, but also in systems architecture, information modeling, and software development/project management. For the past 10 years, his main focus has been database performance analysis and tuning, with much of his time spent exploring the complexities and usefulness of AWR* tuning data. He produces Oracle Database tuning results across 12c/11g/10g (and occasionally 9i) databases. He is a thought-leader in his field, and has been recognized for his expertise in tuning. He has presented at the past eight East Coast Oracle Conferences, as well as at COLLABORATE14 and COLLABORATE18, RMOUG16, and Hotsos 2017-2018.  

Part I. Performance Tuning Basics1. Traditional ApproachesPart II. Dynamic Performance Analytics2. Gathering Problem Information3. Data Preparation4. Statistical Analysis5. Feature Selection6. Taxonomy7. Reporting and Running the CodePart III. Case Studies8. TBD9. TBD10. TBDPart IV. Case Studies and Further Applications11. Monitoring12. Further Enhancements and UsesPart V. AppendixesA. SQL Query Toolbox

Erscheint lt. Verlag 6.12.2018
Zusatzinfo XXI, 224 p. 83 illus.
Verlagsort Berkeley
Sprache englisch
Themenwelt Informatik Datenbanken Oracle
Mathematik / Informatik Informatik Software Entwicklung
Schlagworte Active Session History (ASH) • Analytics • Automatic Database Diagnostic Monitor (ADDM) • Automatic Workload Repository (AWR) • Big Data • machine learning • Oracle Internals • Performance Troubleshooting • performance tuning • root cause analysis • SQL Tuning
ISBN-10 1-4842-4137-1 / 1484241371
ISBN-13 978-1-4842-4137-0 / 9781484241370
Haben Sie eine Frage zum Produkt?
PDFPDF (Wasserzeichen)
Größe: 8,9 MB

DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasser­zeichen und ist damit für Sie persona­lisiert. Bei einer missbräuch­lichen Weiter­gabe des eBooks an Dritte ist eine Rück­ver­folgung an die Quelle möglich.

Dateiformat: PDF (Portable Document Format)
Mit einem festen Seiten­layout eignet sich die PDF besonders für Fach­bücher mit Spalten, Tabellen und Abbild­ungen. Eine PDF kann auf fast allen Geräten ange­zeigt werden, ist aber für kleine Displays (Smart­phone, eReader) nur einge­schränkt geeignet.

Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.

Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.

Mehr entdecken
aus dem Bereich