Expert Oracle SQL optimization, deployment, and statistics
This book is about optimizing individual SQL statements, especially on production database systems. The book describes a systematic process by which to diagnose a problem statement, identify a fix, and to implement that fix safely in a production system. The book contains two chapters of good inform...
Main Author: | |
---|---|
Format: | eBook |
Language: | English |
Published: |
Berkeley, CA, New York, NY
Apress, Distributed to the Book trade worldwide by Springer
2014
|
Series: | The expert's voice in Oracle
|
Subjects: | |
Online Access: | |
Collection: | O'Reilly - Collection details see MPG.ReNa |
Summary: | This book is about optimizing individual SQL statements, especially on production database systems. The book describes a systematic process by which to diagnose a problem statement, identify a fix, and to implement that fix safely in a production system. The book contains two chapters of good information from an experienced professional on how to safely deploy changes into production so that your systems remaining running and available throughout the deployment process. Describes a systematic approach to tuning Oracle SQL; What you'll learn: Determine the root cause of poor performance in a SQL statement; Decipher each line of an execution plan and how it relates to its source SQL statement; Know the various options and transformations available for the Cost-Based Optimizer; Interpret the diagnostic data from Active Session History, SQL Performance Monitor, and from other sources; Apply optimizer hints, SQL profiles, and SQL baselines when they are best used, and avoid them otherwise; Manage object statistics used by the optimizer to ensure efficient execution plans. -- |
---|---|
Physical Description: | xxvii, 571 pages illustrations |
ISBN: | 9781430259787 1430259787 1430259779 |