Cargando…
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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress,
2014.
|
| Colección: | Expert's voice in Oracle.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000Ii 4500 | ||
|---|---|---|---|
| 001 | OR_ocn883298974 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu|||unuuu | ||
| 008 | 140710s2014 caua o 001 0 eng d | ||
| 040 | |a GW5XE |b eng |e rda |e pn |c GW5XE |d BTCTA |d COO |d UMI |d YDXCP |d E7B |d STF |d B24X7 |d IAD |d DEBBG |d DEBSZ |d N$T |d IDEBK |d UPM |d OCLCF |d EBLCP |d OCLCQ |d OCL |d OCLCQ |d Z5A |d LIV |d MERUC |d OCLCQ |d ESU |d OCLCQ |d VT2 |d IOG |d OCLCO |d CEF |d INT |d U3W |d OCLCQ |d WYU |d OCLCO |d YOU |d OCLCQ |d OCLCO |d UAB |d AU@ |d UKAHL |d OCLCQ |d OCLCO |d ERF |d RDF |d OCLCQ |d SFB |d BRF |d REB |d UWO |d TKN |d OCLCO |d OCLCQ |d OCLCO | ||
| 019 | |a 885593917 |a 892538622 |a 918561507 |a 966374290 |a 1005832259 |a 1026459614 |a 1048155990 |a 1065968027 |a 1066690427 |a 1086491255 |a 1112524647 |a 1160630785 |a 1162347175 |a 1192347547 |a 1198254437 |a 1204152519 |a 1206409046 |a 1227400496 |a 1237456027 |a 1244636040 |a 1300437746 | ||
| 020 | |a 9781430259787 |q (electronic bk.) | ||
| 020 | |a 1430259787 |q (electronic bk.) | ||
| 020 | |a 1430259779 |q (print) | ||
| 020 | |a 9781430259770 |q (print) | ||
| 020 | |z 9781430259770 | ||
| 024 | 7 | |a 10.1007/978-1-4302-5978-7 |2 doi | |
| 029 | 1 | |a AU@ |b 000056924325 | |
| 029 | 1 | |a CHNEW |b 000890437 | |
| 029 | 1 | |a CHVBK |b 374491542 | |
| 029 | 1 | |a DEBBG |b BV042182260 | |
| 029 | 1 | |a DEBBG |b BV043617609 | |
| 029 | 1 | |a DEBSZ |b 417229380 | |
| 029 | 1 | |a DEBSZ |b 453673341 | |
| 029 | 1 | |a GBVCP |b 882840436 | |
| 029 | 1 | |a NZ1 |b 15753244 | |
| 029 | 1 | |a AU@ |b 000070675558 | |
| 035 | |a (OCoLC)883298974 |z (OCoLC)885593917 |z (OCoLC)892538622 |z (OCoLC)918561507 |z (OCoLC)966374290 |z (OCoLC)1005832259 |z (OCoLC)1026459614 |z (OCoLC)1048155990 |z (OCoLC)1065968027 |z (OCoLC)1066690427 |z (OCoLC)1086491255 |z (OCoLC)1112524647 |z (OCoLC)1160630785 |z (OCoLC)1162347175 |z (OCoLC)1192347547 |z (OCoLC)1198254437 |z (OCoLC)1204152519 |z (OCoLC)1206409046 |z (OCoLC)1227400496 |z (OCoLC)1237456027 |z (OCoLC)1244636040 |z (OCoLC)1300437746 | ||
| 037 | |a CL0500000461 |b Safari Books Online | ||
| 050 | 4 | |a QA76.73.S67 | |
| 072 | 7 | |a UN |2 bicssc | |
| 072 | 7 | |a UMT |2 bicssc | |
| 072 | 7 | |a COM021000 |2 bisacsh | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.75/65 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Hasler, Tony |c (Software consultant), |e author. | |
| 245 | 1 | 0 | |a Expert Oracle SQL : |b optimization, deployment, and statistics / |c Tony Hasler. |
| 264 | 1 | |a Berkeley, CA : |b Apress, |c 2014. | |
| 264 | 2 | |a New York, NY : |b Distributed to the Book trade worldwide by Springer | |
| 264 | 4 | |c ©2014 | |
| 300 | |a 1 online resource (xxvii, 571 pages) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file |b PDF |2 rda | ||
| 490 | 1 | |a The expert's voice in Oracle | |
| 588 | 0 | |a Online resource; title from PDF title page (SpringerLink, viewed July 8, 2014). | |
| 520 | |a 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. -- |c Edited summary from book. | ||
| 505 | 0 | |a At a Glance; About IOUG Press; Contents; About the Author; About the Technical Reviewers; Acknowledgments; Foreword; Introduction; Part 1: Basic Concepts; Chapter 1: SQL Features; SQL and Declarative Programming Languages; Statements and SQL_IDs; Cross-Referencing Statement and SQL_ID; Array Interface; Subquery Factoring; The Concept of Subquery Factoring; Improving Readability; Using Factored Subqueries Multiple Times; Avoiding the Use of Temporary Tables; Recursive Factored Subqueries; Joins; Inner Joins and Traditional Join Syntax; A Simple Two Table Join; A Four Table Inner Join | |
| 505 | 8 | |a Outer Joins and ANSI Join SyntaxLeft Outer Joins; Right Outer Joins; Full Outer Joins; Partitioned Outer Joins; Summary; Chapter 2: The Cost-Based Optimizer; The Optimal Execution Plan; The Definition of Cost; The CBO's Cost-Estimating Algorithm; Calculating Cost; The Quality of the CBO's Plan Selection; The Accuracy of the CBO's Cost Estimates; Suboptimal Execution Plans; The Optimization Process; Parallelism; Query Transformation; Final State Query Optimization; Summary; Chapter 3: Basic Execution Plan Concepts; Displaying Execution Plans; Displaying the Results of EXPLAIN PLAN | |
| 505 | 8 | |a EXPLAIN PLAN May Be MisleadingDisplaying Output from the Cursor Cache; Displaying Execution Plans from the AWR; Understanding Operations; What an Operation Does; How Operations Interact; Operation 0: SELECT STATEMENT; Operation 1: SORT AGGREGATE; Operation 2: TABLE ACCESS FULL; Operation 3: HASH JOIN; Operations 4 and 5: TABLE FULL SCANs; How Operations Interact Wrap Up; How Long Do Operations Take?; Summary; Chapter 4: The Runtime Engine; Collecting Operation Level Runtime Data; The GATHER_PLAN_STATISTICS Hint; Setting STATISTICS_LEVEL=ALL; Enabling SQL Tracing | |
| 505 | 8 | |a Displaying Operational Level DataDisplaying Runtime Engine Statistics with DBMS_XPLAN. DISPLAY_CURSOR; Displaying Runtime Engine Statistics with VSQL_PLAN_STATISTICS_ALL; Displaying Session Level Statistics with Snapper; The SQL Performance Monitor; Workareas; Operations Needing a Workarea; Allocating Memory to a Workarea; Calculating Memory Allocation When WORKAREA_SIZE_POLICY Is Set to AUTO; Calculating Memory Allocation When WORKAREA_SIZE_POLICY Is Set to MANUAL; Optimal, One-Pass, and Multipass Operations; Shortcuts; Scalar Subquery Caching; Join Shortcuts; Result and OCI Caches | |
| 505 | 8 | |a Function Result CacheSummary; Chapter 5: Introduction to Tuning; Understanding the Problem; Understanding the Business Problem; Understanding the Technical Problem; Understanding the SQL Statement; Understanding the Data; Understanding the Problem Wrap Up; Analysis; Running the Statement to Completion; Analyzing Elapsed Time; When the Elapsed Times Doesn't Add Up; When the Time Does Add Up; Fixing the Problem; Check the Statistics; Changing the Code; Adding Information; Transforming the Query; Adding Hints; Making Physical Changes to the Database; Making Changes to the Environment | |
| 546 | |a English. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Oracle (Computer file) |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 blmlsh |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 fast |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 0 | |a Database management. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a COMPUTERS |x Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 776 | 0 | 8 | |i Printed edition: |z 9781430259770 |
| 830 | 0 | |a Expert's voice in Oracle. | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781430259787/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH29395601 | ||
| 938 | |a Books 24x7 |b B247 |n bks00066688 | ||
| 938 | |a Baker and Taylor |b BTCP |n BK0015485054 | ||
| 938 | |a EBL - Ebook Library |b EBLB |n EBL1964705 | ||
| 938 | |a ebrary |b EBRY |n ebr10896166 | ||
| 938 | |a EBSCOhost |b EBSC |n 1051931 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis28791835 | ||
| 938 | |a YBP Library Services |b YANK |n 12013051 | ||
| 994 | |a 92 |b IZTAP | ||