05222nam 22006254a 450 991081667730332120200520144314.01-281-00716-197866110071640-08-049202-9(CKB)1000000000341464(EBL)294647(OCoLC)437181621(SSID)ssj0000215870(PQKBManifestationID)11912268(PQKBTitleCode)TC0000215870(PQKBWorkID)10185277(PQKB)11041441(Au-PeEL)EBL294647(CaPaEBR)ebr10186554(CaONFJC)MIL100716(MiAaPQ)EBC294647(EXLCZ)99100000000034146420070403d2007 uy 0engur|n|---|||||txtccrOracle performance tuning for 10gR2[electronic resource] /Gavin Powell2nd ed.Burlington, MA Digital Pressc20071 online resource (955 p.)Previous ed. published: New York : Digital Press, c2004, under title: Oracle high performance tuning for 9i and 10g.Includes index.1-55558-345-8 Front 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 Model3.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 Efficiency7.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 Sorting10.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 TuningPart 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 Objects16.5 How Much Block and Extent Tuning?Tuning 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 Relational databasesRelational databases.005.75/85Powell Gavin1608280Powell Gavin1608280MiAaPQMiAaPQMiAaPQBOOK9910816677303321Oracle performance tuning for 10gR23934949UNINA