LEADER 05199nam 22006254a 450 001 9910816677303321 005 20200520144314.0 010 $a1-281-00716-1 010 $a9786611007164 010 $a0-08-049202-9 035 $a(CKB)1000000000341464 035 $a(EBL)294647 035 $a(OCoLC)437181621 035 $a(SSID)ssj0000215870 035 $a(PQKBManifestationID)11912268 035 $a(PQKBTitleCode)TC0000215870 035 $a(PQKBWorkID)10185277 035 $a(PQKB)11041441 035 $a(Au-PeEL)EBL294647 035 $a(CaPaEBR)ebr10186554 035 $a(CaONFJC)MIL100716 035 $a(MiAaPQ)EBC294647 035 $a(EXLCZ)991000000000341464 100 $a20070403d2007 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aOracle performance tuning for 10gR2 /$fGavin Powell 205 $a2nd ed. 210 $aBurlington, MA $cDigital Press$dc2007 215 $a1 online resource (955 p.) 300 $aPrevious ed. published: New York : Digital Press, c2004, under title: Oracle high performance tuning for 9i and 10g. 300 $aIncludes index. 311 $a1-55558-345-8 327 $aFront Cover; Oracle ® Performance Tuning for 10gR2; Copyright Page; Contents; Preface; Introduction; Part I: Data Model Tuning; Chapter 1. The Relational Database Model; 1.1 The Formal Definition of Normalization; 1.2 A Layperson's Approach to Normalization; 1.3 Referential Integrity; Chapter 2. Tuning the Relational Database Model; 2.1 Normalization and Tuning; 2.2 Referential Integrity and Tuning; 2.3 Optimizing with Alternate Indexes; 2.4 Undoing Normalization; Chapter 3. Different Forms of the Relational Database Model; 3.1 The Purist's Relational Database Model 327 $a3.2 Object Applications and the Relational Database ModelChapter 4. A Brief History of Data Modeling; 4.1 The History of Data Modeling; 4.2 The History of Relational Databases; 4.3 The History of the Oracle Database; 4.4 The Roots of SQL; Part II: SQL Code Tuning; Chapter 5. What Is SQL?; 5.1 DML and DDL; 5.2 Transaction Control; 5.3 Parallel Queries; Chapter 6. The Basics of Efficient SQL; 6.1 The SELECT Statement; 6.2 Using Functions; 6.3 Pseudocolumns; 6.4 Comparison Conditions; Chapter 7. Advanced Concepts of Efficient SQL; 7.1 Joins; 7.2 Using Subqueries for Efficiency 327 $a7.3 Using Synonyms7.4 Using Views; 7.5 Temporary Tables; 7.6 Resorting to PL/SQL; 7.7 Object and Relational Conflicts; 7.8 Replacing DELETE with TRUNCATE; Chapter 8. Common-Sense Indexing; 8.1 What and How to Index; 8.2 Types of Indexes; 8.3 Types of Indexes in Oracle Database; 8.4 Tuning BTree Indexes; 8.5 Summarizing Indexes; Chapter 9. Oracle SQL Optimization and Statistics; 9.1 What Is the Parser?; 9.2 What Is the Purpose of the Optimizer?; 9.3 Rule-Based versus Cost-Based Optimization; Chapter 10. How Oracle SQL Optimization Works; 10.1 Data Access Methods; 10.2 Sorting 327 $a10.3 Special CasesChapter 11. Overriding Optimizer Behavior Using Hints; 11.1 How to Use Hints; 11.2 Hints: Suggestion or Force?; 11.3 Classifying Hints; 11.4 Influencing the Optimizer in General; 11.5 10g Naming Query Blocks for Hints; Chapter 12. How to Find Problem Queries; 12.1 Tools to Detect Problems; 12.2 EXPLAIN PLAN; 12.3 SQL Trace and TKPROF; 12.4 TRCSESS; 12.5 Autotrace; 12.6 Oracle Database Performance Views for Tuning SQL; Chapter 13. Automated SQL Tuning; 13.1 Automatic Gathering of Statistics; 13.2 The AWR and the ADDM; 13.3 Automating SQL Tuning 327 $aPart III: Physical and Configuration TuningChapter 14. Tuning Oracle Database File Structures; 14.1 Oracle Database Architecture and the Physical Layer; 14.2 Tuning and the Logical Layer; 14.3 Automating Database File Structures; Chapter 15. Object Tuning; 15.1 Tables; 15.2 Indexes; 15.3 Index-Organized Tables and Clusters; 15.4 Sequences; 15.5 Synonyms and Views; 15.6 The Recycle Bin; Chapter 16. Low-Level Physical Tuning; 16.1 What Is the High-Water Mark?; 16.2 Space Used in a Database; 16.3 What Are Row Chaining and Row Migration?; 16.4 Different Types of Objects 327 $a16.5 How Much Block and Extent Tuning? 330 $aTuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improvement. Physical and configuration tuning often gives at most a 25% performance increase.Gavin Powell shows that the central theme of Oracle10gR2 Performance Tuning is four-fold: denormalize data models to fit applications; tune SQL code according to both the data model and the application 606 $aRelational databases 615 0$aRelational databases. 676 $a005.75/85 700 $aPowell$b Gavin$01608280 701 $aPowell$b Gavin$01608280 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910816677303321 996 $aOracle performance tuning for 10gR2$93934949 997 $aUNINA