Oracle high performance tuning for 9i and 10g /:
There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration. A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the a...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Amsterdam ; Boston :
Elsevier/Digital Press,
©2004.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration. A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. Poorly written SQL code is often a culpri. |
| Beschreibung: | 1 online resource (xxxiv, 738 pages :) |
| ISBN: | 9780080513294 0080513298 1282540149 9781282540149 |
Internformat
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn657323156 | ||
| 003 | OCoLC | ||
| 005 | 20240705115654.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 100823s2004 ne a o 001 0 eng d | ||
| 040 | |a N$T |b eng |e pn |c N$T |d N$T |d YDXCP |d IDEBK |d OCLCQ |d OCLCF |d NLGGC |d EBLCP |d S4S |d DEBSZ |d OCLCQ |d AGLDB |d LIV |d OCLCQ |d MERUC |d OCLCQ |d VTS |d COO |d OCLCQ |d OCLCO |d M8D |d OCLCQ |d OCLCO |d BRF |d OCLCO |d OCLCQ |d OCLCO |d OCLCQ |d OCLCL | ||
| 019 | |a 635293661 |a 697739055 |a 742297438 |a 808998545 |a 816375673 |a 823123627 |a 823845991 |a 823915402 |a 824100430 |a 824157162 | ||
| 020 | |a 9780080513294 |q (electronic bk.) | ||
| 020 | |a 0080513298 |q (electronic bk.) | ||
| 020 | |a 1282540149 | ||
| 020 | |a 9781282540149 | ||
| 035 | |a (OCoLC)657323156 |z (OCoLC)635293661 |z (OCoLC)697739055 |z (OCoLC)742297438 |z (OCoLC)808998545 |z (OCoLC)816375673 |z (OCoLC)823123627 |z (OCoLC)823845991 |z (OCoLC)823915402 |z (OCoLC)824100430 |z (OCoLC)824157162 | ||
| 050 | 4 | |a QA76.9.D3 |b P685 2004eb | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 072 | 7 | |a UNSB, UMT |2 bicssc | |
| 082 | 7 | |a 005.75/65 |2 22 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Powell, Gavin. |0 http://id.loc.gov/authorities/names/n2004004057 | |
| 245 | 1 | 0 | |a Oracle high performance tuning for 9i and 10g / |c Gavin Powell. |
| 260 | |a Amsterdam ; |a Boston : |b Elsevier/Digital Press, |c ©2004. | ||
| 300 | |a 1 online resource (xxxiv, 738 pages :) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |a Front Cover; Oracle® High Performance Tuning for 9i and 1og; Copyright Page; Contents; Contents at a glance; Preface; Introduction; A Tuning Environment; When to Tune; What to Tune in Production; When to Stop Tuning in Production; Tuning from Development to Production; How is this Book Organized?; Some Final Points; What is Oracle Database 10g?; Part I: Data Model Tuning; Chapter 1. The Relational Database Model; 1.1 A Layman's Approach to Normalization; 1.2 Referential Integrity; Chapter 2. Tuning the Relational Database Model; 2.1 Normalization and Tuning. | |
| 505 | 8 | |a 2.2 Referential Integrity and Tuning2.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; 3.2 Object Applications and the Relational Database Model; Chapter 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 DML Command Syntax; 5.3 Transaction Control; 5.4 Parallel Queries. | |
| 505 | 8 | |a Chapter 6. The Basics of Efficient SQL6.1 The SELECT Statement; 6.2 Using Functions; 6.3 Pseudocolumns; 6.4 Comparison Conditions; 6.5 Joins; 6.6 Using Subqueries for Efficiency; 6.7 Using Synonyms; 6.8 Using Views; 6.9 Temporary Tables; 6.10 Resorting to PL/SQL; 6.11 Replacing DELETE with TRUNCATE; 6.12 Object and Relational Conflicts; Chapter 7. Common Sense Indexing; 7.1 What and How to Index; 7.2 Types of Indexes; 7.3 Types of Indexes in Oracle Database; 7.4 Tuning BTree Indexes; 7.5 Summarizing Indexes; Chapter 8. Making SQL Efficient in Oracle Database; 8.1 What is the Parser? | |
| 505 | 8 | |a 8.2 What is the Optimizer?8.3 How Best to Access Data in the Database; 8.4 Rule- versus Cost-Based Optimization; 8.5 Data Access Methods; 8.6 Sorting; 8.7 Special Cases; 8.8 Overriding the Optimizer using Hints; Chapter 9. How to Find Problem Queries; 9.1 Tools to Detect Problems; 9.2 EXPLAIN PLAN; 9.3 SQL Trace and TKPROF; 9.4 10g TRCSESS; 9.5 Autotrace; 9.6 Oracle Database Performance Views for Tuning SQL; Chapter 10. Tuning SQL with Oracle Enterprise Manager; 10.1 The Tuning Pack; Part III: Physical and Configuration Tuning; Chapter 11. Installing Oracle and Creating a Database. | |
| 505 | 8 | |a 11.1 Installing Oracle Database11.2 Basic Configuration; 11.3 Creating a Database; Chapter 12. Tuning Oracle Database File Structures; 12.1 Oracle Database Architecture and the Physical Layer; 12.2 Tuning and the Logical Layer; Chapter 13. Object Tuning; 13.1 Tables; 13.2 Indexes; 13.3 Index-Organized Tables and Clusters; 13.4 Sequences; 13.5 Synonyms and Views; 13.6 10g The Recycle Bin; Chapter 14. Low-Level Physical Tuning; 14.1 What is the High Water Mark?; 14.2 Space Used in a Database; 14.3 What are Row Chaining and Row Migration?; 14.4 Different Types of Objects. | |
| 520 | |a There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration. A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. Poorly written SQL code is often a culpri. | ||
| 630 | 0 | 0 | |a Oracle (Computer file) |0 http://id.loc.gov/authorities/names/n91015760 |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 fast |
| 650 | 0 | |a Relational databases. |0 http://id.loc.gov/authorities/subjects/sh86007768 | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 7 | |a COMPUTERS |x Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a Relational databases |2 fast | |
| 758 | |i has work: |a Oracle high performance tuning for 9i and 10g (Text) |1 https://id.oclc.org/worldcat/entity/E39PCGyt4gyk8D9jWCHTPX6qcP |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Powell, Gavin. |t Oracle high performance tuning for 9i and 10g. |d New York : Digital Press, ©2004 |z 9781555583057 |w (DLC) 2004269476 |w (OCoLC)54857917 |
| 856 | 1 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=320842 |3 Volltext | |
| 856 | 1 | |l CBO01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=320842 |3 Volltext | |
| 938 | |a EBL - Ebook Library |b EBLB |n EBL535238 | ||
| 938 | |a EBSCOhost |b EBSC |n 320842 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n 254014 | ||
| 938 | |a YBP Library Services |b YANK |n 3250714 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn657323156 |
|---|---|
| _version_ | 1813903380191379456 |
| adam_text | |
| any_adam_object | |
| author | Powell, Gavin |
| author_GND | http://id.loc.gov/authorities/names/n2004004057 |
| author_facet | Powell, Gavin |
| author_role | |
| author_sort | Powell, Gavin |
| author_variant | g p gp |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3 P685 2004eb |
| callnumber-search | QA76.9.D3 P685 2004eb |
| callnumber-sort | QA 276.9 D3 P685 42004EB |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | Front Cover; Oracle® High Performance Tuning for 9i and 1og; Copyright Page; Contents; Contents at a glance; Preface; Introduction; A Tuning Environment; When to Tune; What to Tune in Production; When to Stop Tuning in Production; Tuning from Development to Production; How is this Book Organized?; Some Final Points; What is Oracle Database 10g?; Part I: Data Model Tuning; Chapter 1. The Relational Database Model; 1.1 A Layman's Approach to Normalization; 1.2 Referential Integrity; Chapter 2. Tuning the Relational Database Model; 2.1 Normalization and Tuning. 2.2 Referential Integrity and Tuning2.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; 3.2 Object Applications and the Relational Database Model; Chapter 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 DML Command Syntax; 5.3 Transaction Control; 5.4 Parallel Queries. Chapter 6. The Basics of Efficient SQL6.1 The SELECT Statement; 6.2 Using Functions; 6.3 Pseudocolumns; 6.4 Comparison Conditions; 6.5 Joins; 6.6 Using Subqueries for Efficiency; 6.7 Using Synonyms; 6.8 Using Views; 6.9 Temporary Tables; 6.10 Resorting to PL/SQL; 6.11 Replacing DELETE with TRUNCATE; 6.12 Object and Relational Conflicts; Chapter 7. Common Sense Indexing; 7.1 What and How to Index; 7.2 Types of Indexes; 7.3 Types of Indexes in Oracle Database; 7.4 Tuning BTree Indexes; 7.5 Summarizing Indexes; Chapter 8. Making SQL Efficient in Oracle Database; 8.1 What is the Parser? 8.2 What is the Optimizer?8.3 How Best to Access Data in the Database; 8.4 Rule- versus Cost-Based Optimization; 8.5 Data Access Methods; 8.6 Sorting; 8.7 Special Cases; 8.8 Overriding the Optimizer using Hints; Chapter 9. How to Find Problem Queries; 9.1 Tools to Detect Problems; 9.2 EXPLAIN PLAN; 9.3 SQL Trace and TKPROF; 9.4 10g TRCSESS; 9.5 Autotrace; 9.6 Oracle Database Performance Views for Tuning SQL; Chapter 10. Tuning SQL with Oracle Enterprise Manager; 10.1 The Tuning Pack; Part III: Physical and Configuration Tuning; Chapter 11. Installing Oracle and Creating a Database. 11.1 Installing Oracle Database11.2 Basic Configuration; 11.3 Creating a Database; Chapter 12. Tuning Oracle Database File Structures; 12.1 Oracle Database Architecture and the Physical Layer; 12.2 Tuning and the Logical Layer; Chapter 13. Object Tuning; 13.1 Tables; 13.2 Indexes; 13.3 Index-Organized Tables and Clusters; 13.4 Sequences; 13.5 Synonyms and Views; 13.6 10g The Recycle Bin; Chapter 14. Low-Level Physical Tuning; 14.1 What is the High Water Mark?; 14.2 Space Used in a Database; 14.3 What are Row Chaining and Row Migration?; 14.4 Different Types of Objects. |
| ctrlnum | (OCoLC)657323156 |
| dewey-full | 005.75/65 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/65 |
| dewey-search | 005.75/65 |
| dewey-sort | 15.75 265 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>06206cam a2200577 a 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn657323156</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20240705115654.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cnu---unuuu</controlfield><controlfield tag="008">100823s2004 ne a o 001 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">N$T</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">N$T</subfield><subfield code="d">N$T</subfield><subfield code="d">YDXCP</subfield><subfield code="d">IDEBK</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCF</subfield><subfield code="d">NLGGC</subfield><subfield code="d">EBLCP</subfield><subfield code="d">S4S</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">AGLDB</subfield><subfield code="d">LIV</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">MERUC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">VTS</subfield><subfield code="d">COO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">M8D</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">BRF</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCL</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">635293661</subfield><subfield code="a">697739055</subfield><subfield code="a">742297438</subfield><subfield code="a">808998545</subfield><subfield code="a">816375673</subfield><subfield code="a">823123627</subfield><subfield code="a">823845991</subfield><subfield code="a">823915402</subfield><subfield code="a">824100430</subfield><subfield code="a">824157162</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780080513294</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0080513298</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1282540149</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781282540149</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)657323156</subfield><subfield code="z">(OCoLC)635293661</subfield><subfield code="z">(OCoLC)697739055</subfield><subfield code="z">(OCoLC)742297438</subfield><subfield code="z">(OCoLC)808998545</subfield><subfield code="z">(OCoLC)816375673</subfield><subfield code="z">(OCoLC)823123627</subfield><subfield code="z">(OCoLC)823845991</subfield><subfield code="z">(OCoLC)823915402</subfield><subfield code="z">(OCoLC)824100430</subfield><subfield code="z">(OCoLC)824157162</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.D3</subfield><subfield code="b">P685 2004eb</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">051170</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">UNSB, UMT</subfield><subfield code="2">bicssc</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.75/65</subfield><subfield code="2">22</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Powell, Gavin.</subfield><subfield code="0">http://id.loc.gov/authorities/names/n2004004057</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Oracle high performance tuning for 9i and 10g /</subfield><subfield code="c">Gavin Powell.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Amsterdam ;</subfield><subfield code="a">Boston :</subfield><subfield code="b">Elsevier/Digital Press,</subfield><subfield code="c">©2004.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (xxxiv, 738 pages :)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Print version record.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Front Cover; Oracle® High Performance Tuning for 9i and 1og; Copyright Page; Contents; Contents at a glance; Preface; Introduction; A Tuning Environment; When to Tune; What to Tune in Production; When to Stop Tuning in Production; Tuning from Development to Production; How is this Book Organized?; Some Final Points; What is Oracle Database 10g?; Part I: Data Model Tuning; Chapter 1. The Relational Database Model; 1.1 A Layman's Approach to Normalization; 1.2 Referential Integrity; Chapter 2. Tuning the Relational Database Model; 2.1 Normalization and Tuning.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">2.2 Referential Integrity and Tuning2.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; 3.2 Object Applications and the Relational Database Model; Chapter 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 DML Command Syntax; 5.3 Transaction Control; 5.4 Parallel Queries.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Chapter 6. The Basics of Efficient SQL6.1 The SELECT Statement; 6.2 Using Functions; 6.3 Pseudocolumns; 6.4 Comparison Conditions; 6.5 Joins; 6.6 Using Subqueries for Efficiency; 6.7 Using Synonyms; 6.8 Using Views; 6.9 Temporary Tables; 6.10 Resorting to PL/SQL; 6.11 Replacing DELETE with TRUNCATE; 6.12 Object and Relational Conflicts; Chapter 7. Common Sense Indexing; 7.1 What and How to Index; 7.2 Types of Indexes; 7.3 Types of Indexes in Oracle Database; 7.4 Tuning BTree Indexes; 7.5 Summarizing Indexes; Chapter 8. Making SQL Efficient in Oracle Database; 8.1 What is the Parser?</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">8.2 What is the Optimizer?8.3 How Best to Access Data in the Database; 8.4 Rule- versus Cost-Based Optimization; 8.5 Data Access Methods; 8.6 Sorting; 8.7 Special Cases; 8.8 Overriding the Optimizer using Hints; Chapter 9. How to Find Problem Queries; 9.1 Tools to Detect Problems; 9.2 EXPLAIN PLAN; 9.3 SQL Trace and TKPROF; 9.4 10g TRCSESS; 9.5 Autotrace; 9.6 Oracle Database Performance Views for Tuning SQL; Chapter 10. Tuning SQL with Oracle Enterprise Manager; 10.1 The Tuning Pack; Part III: Physical and Configuration Tuning; Chapter 11. Installing Oracle and Creating a Database.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">11.1 Installing Oracle Database11.2 Basic Configuration; 11.3 Creating a Database; Chapter 12. Tuning Oracle Database File Structures; 12.1 Oracle Database Architecture and the Physical Layer; 12.2 Tuning and the Logical Layer; Chapter 13. Object Tuning; 13.1 Tables; 13.2 Indexes; 13.3 Index-Organized Tables and Clusters; 13.4 Sequences; 13.5 Synonyms and Views; 13.6 10g The Recycle Bin; Chapter 14. Low-Level Physical Tuning; 14.1 What is the High Water Mark?; 14.2 Space Used in a Database; 14.3 What are Row Chaining and Row Migration?; 14.4 Different Types of Objects.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration. A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. Poorly written SQL code is often a culpri.</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">Oracle (Computer file)</subfield><subfield code="0">http://id.loc.gov/authorities/names/n91015760</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">Oracle (Computer file)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Relational databases.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh86007768</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données relationnelles.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Programming Languages</subfield><subfield code="x">SQL.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Relational databases</subfield><subfield code="2">fast</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">Oracle high performance tuning for 9i and 10g (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCGyt4gyk8D9jWCHTPX6qcP</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Powell, Gavin.</subfield><subfield code="t">Oracle high performance tuning for 9i and 10g.</subfield><subfield code="d">New York : Digital Press, ©2004</subfield><subfield code="z">9781555583057</subfield><subfield code="w">(DLC) 2004269476</subfield><subfield code="w">(OCoLC)54857917</subfield></datafield><datafield tag="856" ind1="1" ind2=" "><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=320842</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="856" ind1="1" ind2=" "><subfield code="l">CBO01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=320842</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBL - Ebook Library</subfield><subfield code="b">EBLB</subfield><subfield code="n">EBL535238</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">320842</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest MyiLibrary Digital eBook Collection</subfield><subfield code="b">IDEB</subfield><subfield code="n">254014</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">3250714</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-ocn657323156 |
| illustrated | Illustrated |
| indexdate | 2024-10-25T16:17:46Z |
| institution | BVB |
| isbn | 9780080513294 0080513298 1282540149 9781282540149 |
| language | English |
| oclc_num | 657323156 |
| open_access_boolean | |
| owner | MAIN |
| owner_facet | MAIN |
| physical | 1 online resource (xxxiv, 738 pages :) |
| psigel | ZDB-4-EBA |
| publishDate | 2004 |
| publishDateSearch | 2004 |
| publishDateSort | 2004 |
| publisher | Elsevier/Digital Press, |
| record_format | marc |
| spelling | Powell, Gavin. http://id.loc.gov/authorities/names/n2004004057 Oracle high performance tuning for 9i and 10g / Gavin Powell. Amsterdam ; Boston : Elsevier/Digital Press, ©2004. 1 online resource (xxxiv, 738 pages :) text txt rdacontent computer c rdamedia online resource cr rdacarrier Print version record. Front Cover; Oracle® High Performance Tuning for 9i and 1og; Copyright Page; Contents; Contents at a glance; Preface; Introduction; A Tuning Environment; When to Tune; What to Tune in Production; When to Stop Tuning in Production; Tuning from Development to Production; How is this Book Organized?; Some Final Points; What is Oracle Database 10g?; Part I: Data Model Tuning; Chapter 1. The Relational Database Model; 1.1 A Layman's Approach to Normalization; 1.2 Referential Integrity; Chapter 2. Tuning the Relational Database Model; 2.1 Normalization and Tuning. 2.2 Referential Integrity and Tuning2.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; 3.2 Object Applications and the Relational Database Model; Chapter 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 DML Command Syntax; 5.3 Transaction Control; 5.4 Parallel Queries. Chapter 6. The Basics of Efficient SQL6.1 The SELECT Statement; 6.2 Using Functions; 6.3 Pseudocolumns; 6.4 Comparison Conditions; 6.5 Joins; 6.6 Using Subqueries for Efficiency; 6.7 Using Synonyms; 6.8 Using Views; 6.9 Temporary Tables; 6.10 Resorting to PL/SQL; 6.11 Replacing DELETE with TRUNCATE; 6.12 Object and Relational Conflicts; Chapter 7. Common Sense Indexing; 7.1 What and How to Index; 7.2 Types of Indexes; 7.3 Types of Indexes in Oracle Database; 7.4 Tuning BTree Indexes; 7.5 Summarizing Indexes; Chapter 8. Making SQL Efficient in Oracle Database; 8.1 What is the Parser? 8.2 What is the Optimizer?8.3 How Best to Access Data in the Database; 8.4 Rule- versus Cost-Based Optimization; 8.5 Data Access Methods; 8.6 Sorting; 8.7 Special Cases; 8.8 Overriding the Optimizer using Hints; Chapter 9. How to Find Problem Queries; 9.1 Tools to Detect Problems; 9.2 EXPLAIN PLAN; 9.3 SQL Trace and TKPROF; 9.4 10g TRCSESS; 9.5 Autotrace; 9.6 Oracle Database Performance Views for Tuning SQL; Chapter 10. Tuning SQL with Oracle Enterprise Manager; 10.1 The Tuning Pack; Part III: Physical and Configuration Tuning; Chapter 11. Installing Oracle and Creating a Database. 11.1 Installing Oracle Database11.2 Basic Configuration; 11.3 Creating a Database; Chapter 12. Tuning Oracle Database File Structures; 12.1 Oracle Database Architecture and the Physical Layer; 12.2 Tuning and the Logical Layer; Chapter 13. Object Tuning; 13.1 Tables; 13.2 Indexes; 13.3 Index-Organized Tables and Clusters; 13.4 Sequences; 13.5 Synonyms and Views; 13.6 10g The Recycle Bin; Chapter 14. Low-Level Physical Tuning; 14.1 What is the High Water Mark?; 14.2 Space Used in a Database; 14.3 What are Row Chaining and Row Migration?; 14.4 Different Types of Objects. There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration. A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. Poorly written SQL code is often a culpri. Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) fast Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Bases de données relationnelles. COMPUTERS Programming Languages SQL. bisacsh Relational databases fast has work: Oracle high performance tuning for 9i and 10g (Text) https://id.oclc.org/worldcat/entity/E39PCGyt4gyk8D9jWCHTPX6qcP https://id.oclc.org/worldcat/ontology/hasWork Print version: Powell, Gavin. Oracle high performance tuning for 9i and 10g. New York : Digital Press, ©2004 9781555583057 (DLC) 2004269476 (OCoLC)54857917 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=320842 Volltext CBO01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=320842 Volltext |
| spellingShingle | Powell, Gavin Oracle high performance tuning for 9i and 10g / Front Cover; Oracle® High Performance Tuning for 9i and 1og; Copyright Page; Contents; Contents at a glance; Preface; Introduction; A Tuning Environment; When to Tune; What to Tune in Production; When to Stop Tuning in Production; Tuning from Development to Production; How is this Book Organized?; Some Final Points; What is Oracle Database 10g?; Part I: Data Model Tuning; Chapter 1. The Relational Database Model; 1.1 A Layman's Approach to Normalization; 1.2 Referential Integrity; Chapter 2. Tuning the Relational Database Model; 2.1 Normalization and Tuning. 2.2 Referential Integrity and Tuning2.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; 3.2 Object Applications and the Relational Database Model; Chapter 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 DML Command Syntax; 5.3 Transaction Control; 5.4 Parallel Queries. Chapter 6. The Basics of Efficient SQL6.1 The SELECT Statement; 6.2 Using Functions; 6.3 Pseudocolumns; 6.4 Comparison Conditions; 6.5 Joins; 6.6 Using Subqueries for Efficiency; 6.7 Using Synonyms; 6.8 Using Views; 6.9 Temporary Tables; 6.10 Resorting to PL/SQL; 6.11 Replacing DELETE with TRUNCATE; 6.12 Object and Relational Conflicts; Chapter 7. Common Sense Indexing; 7.1 What and How to Index; 7.2 Types of Indexes; 7.3 Types of Indexes in Oracle Database; 7.4 Tuning BTree Indexes; 7.5 Summarizing Indexes; Chapter 8. Making SQL Efficient in Oracle Database; 8.1 What is the Parser? 8.2 What is the Optimizer?8.3 How Best to Access Data in the Database; 8.4 Rule- versus Cost-Based Optimization; 8.5 Data Access Methods; 8.6 Sorting; 8.7 Special Cases; 8.8 Overriding the Optimizer using Hints; Chapter 9. How to Find Problem Queries; 9.1 Tools to Detect Problems; 9.2 EXPLAIN PLAN; 9.3 SQL Trace and TKPROF; 9.4 10g TRCSESS; 9.5 Autotrace; 9.6 Oracle Database Performance Views for Tuning SQL; Chapter 10. Tuning SQL with Oracle Enterprise Manager; 10.1 The Tuning Pack; Part III: Physical and Configuration Tuning; Chapter 11. Installing Oracle and Creating a Database. 11.1 Installing Oracle Database11.2 Basic Configuration; 11.3 Creating a Database; Chapter 12. Tuning Oracle Database File Structures; 12.1 Oracle Database Architecture and the Physical Layer; 12.2 Tuning and the Logical Layer; Chapter 13. Object Tuning; 13.1 Tables; 13.2 Indexes; 13.3 Index-Organized Tables and Clusters; 13.4 Sequences; 13.5 Synonyms and Views; 13.6 10g The Recycle Bin; Chapter 14. Low-Level Physical Tuning; 14.1 What is the High Water Mark?; 14.2 Space Used in a Database; 14.3 What are Row Chaining and Row Migration?; 14.4 Different Types of Objects. Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) fast Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Bases de données relationnelles. COMPUTERS Programming Languages SQL. bisacsh Relational databases fast |
| subject_GND | http://id.loc.gov/authorities/names/n91015760 http://id.loc.gov/authorities/subjects/sh86007768 |
| title | Oracle high performance tuning for 9i and 10g / |
| title_auth | Oracle high performance tuning for 9i and 10g / |
| title_exact_search | Oracle high performance tuning for 9i and 10g / |
| title_full | Oracle high performance tuning for 9i and 10g / Gavin Powell. |
| title_fullStr | Oracle high performance tuning for 9i and 10g / Gavin Powell. |
| title_full_unstemmed | Oracle high performance tuning for 9i and 10g / Gavin Powell. |
| title_short | Oracle high performance tuning for 9i and 10g / |
| title_sort | oracle high performance tuning for 9i and 10g |
| topic | Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) fast Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Bases de données relationnelles. COMPUTERS Programming Languages SQL. bisacsh Relational databases fast |
| topic_facet | Oracle (Computer file) Relational databases. Bases de données relationnelles. COMPUTERS Programming Languages SQL. Relational databases |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=320842 |
| work_keys_str_mv | AT powellgavin oraclehighperformancetuningfor9iand10g |