Expert Oracle SQL : optimization, deployment, and statistics / Tony Hasler.
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...
Saved in:
| Online Access: |
Full Text (via O'Reilly/Safari) |
|---|---|
| Main Author: | |
| Format: | eBook |
| Language: | English |
| Published: |
Berkeley, CA :
Apress,
2014.
|
| Series: | Expert's voice in Oracle.
|
| Subjects: |
| 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: | 1 online resource (xxvii, 571 pages) : illustrations |
| ISBN: | 9781430259787 1430259787 1430259779 9781430259770 |
| Language: | English. |
| Source of Description, Etc. Note: | Online resource; title from PDF title page (SpringerLink, viewed July 8, 2014). |