Dynamic Oracle performance analytics : using normalized metrics to improve database speed /: using normalized metrics to improve database speed. (2018)
- Record Type:
- Book
- Title:
- Dynamic Oracle performance analytics : using normalized metrics to improve database speed /: using normalized metrics to improve database speed. (2018)
- Main Title:
- Dynamic Oracle performance analytics : using normalized metrics to improve database speed
- 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/SetIntro; 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 … (more)
- 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.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.380735
- Ingest File:
- 02_369.xml