عنوان

Dynamic Oracle performance analytics :

شابک

1484241371

شابک

9781484241370

شابک اشتباه

9781484241363

عنوان اصلي

Dynamic Oracle performance analytics :

نام عام مواد

[Book]

ساير اطلاعات عنواني

using normalized metrics to improve database speed /

نام نخستين پديدآور

Roger Cornejo.

محل نشرو پخش و غیره

New York :

نام ناشر، پخش کننده و غيره

Apress,

تاریخ نشرو بخش و غیره

2018.

نام خاص و کميت اثر

1 online resource

متن يادداشت

Includes bibliographical references and index.

متن يادداشت

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?

متن يادداشت

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

متن يادداشت

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

متن يادداشت

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

متن يادداشت

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

بدون عنوان

0

بدون عنوان

8

بدون عنوان

8

بدون عنوان

8

بدون عنوان

8

متن يادداشت

Use an innovative approach that relies on big data and advanced analytical techniques to analyze and improve Oracle Database performance. The approach in this book is a step-change 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 draw impactful, focused performance improvement conclusions. This book reviews past and present practices, along with available tools, to help you pinpoint areas for improvement. 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.

منبع سفارش / آدرس اشتراک

Springer Nature

شماره انبار

com.springer.onix.9781484241370

موضوع مستند نشده

Oracle (Computer file)

موضوع مستند نشده

Oracle (Computer file)

موضوع مستند نشده

Database management.

موضوع مستند نشده

Relational databases.

موضوع مستند نشده

COMPUTERS-- Data Processing.

موضوع مستند نشده

Database management.

موضوع مستند نشده

Relational databases.

موضوع مستند نشده

COM-- 018000

شماره

ويراست

شماره رده

مستند نام اشخاص تاييد نشده

Cornejo, Roger.

تاريخ عمليات

20200823032546.0

قواعد فهرست نويسي ( بخش توصيفي )

pn

نام الکترونيکي

نوع ماده

[Book]

تكميل شده

Y