Dynamic Oracle performance analytics : using normalized metrics to improve database speed /: using normalized metrics to improve database speed. (2018)

• Record Type: Book
• Further Information: Note: Roger Cornejo.
• Authors: Cornejo, Roger
• Contents: Intro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Part I: Performance Tuning Basics; Chapter 1: Performance Tuning Basics; OEM; ASH Reports; AWR; ADDM; Summary; Part II: The Dynamic Oracle Performance Analytics (DOPA) Process; Chapter 2: Gathering Problem Information; Has This Run Before?; When Did the Problem Start?; What Was the Start and End Time of the Application Run?; What Database Were You Connected To?; What User Accounts Are They Using to Connect to the Database?; What SQL Do You Believe You Were Running? What Is the Expected Duration?Did You Receive Any Oracle Error Messages?; Summary; Chapter 3: Data Preparation; Normalize the Data; Convert to Delta Values; Union Data from All Sources; Custom Queries; Summary; Chapter 4: Statistical Analysis; Statistics Review; Calculating the Sample Variance Using the Oracle Function; Statistics in the DOPA Process; Summary; Chapter 5: Feature Selection; Summary; Chapter 6: Taxonomy; Why Use Taxonomies?; Infrastructure Taxonomy; Oracle Taxonomy; The Taxonomy Table; Code Snippet for Building the Taxonomies; Summary Chapter 7: Building the Model and ReportingBringing Together the DOPA Process Components; Implementing the DOPA Process: The SQL Code; Precondition to Running the DOPA Process; Running the DOPA Process; Documenting Model Parameters; Variables for Building the Model; Reporting; General Instructions for Building and Tweaking the Model; How to Choose Inputs/Set Variables; Example: Building the Model and Reporting; Summary; Part III: Case Studies and Further Applications; Chapter 8: Case Studies; Case Studies; Case #1: Basic Example Showing How DOPA Process Identifies a SQL Problem Case #2: Basic Example of How the DOPA Process Identified a Configuration ProblemCase #3: CPU Problem Caused by SQL Execution; Case #4: Example Where the DOPA Process Was Used to Detail Problem Areas; Case #5: Performance Investigation for Ill-Described Problem (a Narrative); Case #6: Example of Where Someone Might Think It Was a Top SQL, but It's Not; Case #7: Alert Log Example (Error Alert Failure Example) Narrative; Case #8: DOPA Analysis of Oracle Memory Error-Narrative; Summary; Chapter 9: Monitoring; Development Requirements for DOPA to Be Used for Monitoring; Persisting Baselines Further Thoughts on the Study of Normal RangesAlerting via Absolute Values; Alerting via Percentiles; Summary; Chapter 10: Further Enhancements; Introductory Statement; Metrics Analysis; Implementing Other Sources/Customized Metrics; Active Session History; Regressed SQL: dba_hist_sqlstat; Advisor Analysis: DBA_ADVISOR% Queries for Recommended Action; Application of This Approach to V Tables and StatsPack; Application of This Approach to Other Metrics Collection Sources in the Infrastructure; Application of This Approach to Other Database Management Systems Such As Postgres or MongoDB
• Publisher Details: New York : Springer Nature Apress
• Publication Date: 2018
• Extent: 1 online resource
• Subjects: 005.7565; COMPUTERS / Data Processing; Relational databases; Database management; Database management; Relational databases; Electronic books
• Languages: English
• ISBNs: 9781484241370; 1484241371
• Related ISBNs: 9781484241363
• Notes: Note: Includes bibliographical references and index.; Note: Online resource; title from PDF title page (EBSCO, viewed December 12, 2018).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.