Oracle performance tuning for 10gR2:
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Burlington, MA
Digital Press
c2007
|
| Ausgabe: | 2nd ed |
| Schlagworte: | |
| Online-Zugang: | FAW01 FAW02 Volltext |
| Beschreibung: | Previous ed. published: New York : Digital Press, c2004, under title: Oracle high performance tuning for 9i and 10g. - Includes index 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 in relation to scalability; create a well-proportioned physical architecture at the time of initial Oracle installation; and most important, mix skill sets to obtain the best results. * Fully updated for version 10gR2 and provides all necessary transition material from version 9i * Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning * Contains experienced guidance and real-world examples using large datasets Emphasizes development as opposed to operating system perspective Preface -- Introduction -- Part I. Data Model Tuning -- Chapter 1. The Relational Database Model -- Chapter 2. Tuning the Relational Database Model -- Chapter 3. Different Forms of the Relational Database Model -- Chapter 4. A Brief History of Data Modeling -- Part II. SQL Code Tuning -- Chapter 5. What is SQL? -- Chapter 6. Basic Concepts of Efficient SQL -- Chapter 7. Advanced Concepts of Efficient SQL -- Chapter 8. Common Sense Indexing -- Chapter 9. Oracle SQL Optimization and Statistics -- Chapter 10. How Oracle SQL Optimization Works -- Chapter 11. Overriding Optimizer Behavior Using Hints -- Chapter 12. How to Find Problem Queries -- Chapter 13. Automated SQL Tuning -- Part III. Physical and Configuration Tuning -- Chapter 14. Installing Oracle and Creating a Database -- Chapter 15. Tuning Oracle Database File Structures -- Chapter 16. Object Tuning -- Chapter 17. Low Level Physical Tuning -- Chapter 18. Hardware Resource Usage Tuning -- Chapter 19. Tuning Network Usage -- Chapter 20. Oracle Partitioning and Parallelism -- Chapter 21. Ratios: Possible Symptoms of Problems -- Chapter 22. Wait Events -- Chapter 23. Latches -- Chapter 24. Tools and Utilities -- Part IV. Tuning Everything at Once -- Chapter 25. The Wait Event Interface -- Chapter 26. The Database Control -- Chapter 27. Tuning With STATSPACK -- Appendices -- Appendix A. Sample Databases -- Appendix B. Sample Scripts (script changes) -- Appendix C. Sources of Information (accreditations)Appendix D. SQL Tuning in Oracle Enterprise Manager -- (might delete this one, depending on how much I remove from part III, which is 9i) pt. 1. Data model turning -- The relational database model -- Turning the relational database model -- Different forms of the relational database model -- A brief history of data modeling -- pt. 2 SQL code tuning -- What is SQL? -- The basics of efficient SQL -- Advanced concepts of efficient SQL -- Common-sense indexing -- Oracle SQL optimization and statistics -- How Oracle SQL optimization works -- Overriding optimizer behavior using hints -- How to find problem queries -- 10g automated SQL tuning -- pt. 3. Physical and configuration tuning -- Tuning Oracle database file structures -- Object tuning -- Low-level physical tuning -- Hardware resource usage tuning -- Tuning network usage -- Oracle partitioning and parallelism -- pt. 4. Tuning everything at once -- Ratios: possible symptoms of problems -- Wait events -- Latches -- Tools and utilities -- The wait event interface -- 9i tuning with STATSPACK. |
| Beschreibung: | 1 Online-Ressource (xlix, 904 p.) |
| ISBN: | 0080492029 1555583458 9780080492025 9781555583453 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV043044826 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 151123s2007 |||| o||u| ||||||eng d | ||
| 020 | |a 0080492029 |c electronic bk. |9 0-08-049202-9 | ||
| 020 | |a 1555583458 |9 1-55558-345-8 | ||
| 020 | |a 9780080492025 |c electronic bk. |9 978-0-08-049202-5 | ||
| 020 | |a 9781555583453 |9 978-1-55558-345-3 | ||
| 035 | |a (OCoLC)162595444 | ||
| 035 | |a (DE-599)BVBBV043044826 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1046 |a DE-1047 | ||
| 082 | 0 | |a 005.75/85 |2 22 | |
| 100 | 1 | |a Powell, Gavin |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Oracle performance tuning for 10gR2 |c Gavin Powell |
| 250 | |a 2nd ed | ||
| 264 | 1 | |a Burlington, MA |b Digital Press |c c2007 | |
| 300 | |a 1 Online-Ressource (xlix, 904 p.) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 500 | |a Previous ed. published: New York : Digital Press, c2004, under title: Oracle high performance tuning for 9i and 10g. - Includes index | ||
| 500 | |a 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 in relation to scalability; create a well-proportioned physical architecture at the time of initial Oracle installation; and most important, mix skill sets to obtain the best results. * Fully updated for version 10gR2 and provides all necessary transition material from version 9i * Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning * Contains experienced guidance and real-world examples using large datasets Emphasizes development as opposed to operating system perspective | ||
| 500 | |a Preface -- Introduction -- Part I. Data Model Tuning -- Chapter 1. The Relational Database Model -- Chapter 2. Tuning the Relational Database Model -- Chapter 3. Different Forms of the Relational Database Model -- Chapter 4. A Brief History of Data Modeling -- Part II. SQL Code Tuning -- Chapter 5. What is SQL? -- Chapter 6. Basic Concepts of Efficient SQL -- Chapter 7. Advanced Concepts of Efficient SQL -- Chapter 8. Common Sense Indexing -- Chapter 9. Oracle SQL Optimization and Statistics -- Chapter 10. How Oracle SQL Optimization Works -- Chapter 11. Overriding Optimizer Behavior Using Hints -- Chapter 12. How to Find Problem Queries -- Chapter 13. Automated SQL Tuning -- Part III. Physical and Configuration Tuning -- Chapter 14. Installing Oracle and Creating a Database -- Chapter 15. Tuning Oracle Database File Structures -- Chapter 16. Object Tuning -- Chapter 17. Low Level Physical Tuning -- Chapter 18. Hardware Resource Usage Tuning -- Chapter 19. Tuning Network Usage -- Chapter 20. Oracle Partitioning and Parallelism -- Chapter 21. Ratios: Possible Symptoms of Problems -- Chapter 22. Wait Events -- Chapter 23. Latches -- Chapter 24. Tools and Utilities -- Part IV. Tuning Everything at Once -- Chapter 25. The Wait Event Interface -- Chapter 26. The Database Control -- Chapter 27. Tuning With STATSPACK -- Appendices -- Appendix A. Sample Databases -- Appendix B. Sample Scripts (script changes) -- Appendix C. Sources of Information (accreditations)Appendix D. SQL Tuning in Oracle Enterprise Manager -- (might delete this one, depending on how much I remove from part III, which is 9i) | ||
| 500 | |a pt. 1. Data model turning -- The relational database model -- Turning the relational database model -- Different forms of the relational database model -- A brief history of data modeling -- pt. 2 SQL code tuning -- What is SQL? -- The basics of efficient SQL -- Advanced concepts of efficient SQL -- Common-sense indexing -- Oracle SQL optimization and statistics -- How Oracle SQL optimization works -- Overriding optimizer behavior using hints -- How to find problem queries -- 10g automated SQL tuning -- pt. 3. Physical and configuration tuning -- Tuning Oracle database file structures -- Object tuning -- Low-level physical tuning -- Hardware resource usage tuning -- Tuning network usage -- Oracle partitioning and parallelism -- pt. 4. Tuning everything at once -- Ratios: possible symptoms of problems -- Wait events -- Latches -- Tools and utilities -- The wait event interface -- 9i tuning with STATSPACK. | ||
| 630 | 0 | 4 | |a Oracle (Computer file) |
| 650 | 7 | |a COMPUTERS / Data Processing |2 bisacsh | |
| 650 | 7 | |a Oracle (Computer file) |2 blmlsh | |
| 650 | 7 | |a Relational databases |2 local | |
| 650 | 4 | |a Oracle (Computer file) | |
| 650 | 4 | |a Relational databases | |
| 700 | 1 | |a Powell, Gavin |e Sonstige |4 oth | |
| 856 | 4 | 0 | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=195157 |x Aggregator |3 Volltext |
| 912 | |a ZDB-4-EBA | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-028469364 | ||
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=195157 |l FAW01 |p ZDB-4-EBA |q FAW_PDA_EBA |x Aggregator |3 Volltext | |
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=195157 |l FAW02 |p ZDB-4-EBA |q FAW_PDA_EBA |x Aggregator |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1804175411062505472 |
|---|---|
| any_adam_object | |
| author | Powell, Gavin |
| author_facet | Powell, Gavin |
| author_role | aut |
| author_sort | Powell, Gavin |
| author_variant | g p gp |
| building | Verbundindex |
| bvnumber | BV043044826 |
| collection | ZDB-4-EBA |
| ctrlnum | (OCoLC)162595444 (DE-599)BVBBV043044826 |
| dewey-full | 005.75/85 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/85 |
| dewey-search | 005.75/85 |
| dewey-sort | 15.75 285 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 2nd ed |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>05622nmm a2200493zc 4500</leader><controlfield tag="001">BV043044826</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">151123s2007 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0080492029</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">0-08-049202-9</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1555583458</subfield><subfield code="9">1-55558-345-8</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780080492025</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-0-08-049202-5</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781555583453</subfield><subfield code="9">978-1-55558-345-3</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)162595444</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV043044826</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1046</subfield><subfield code="a">DE-1047</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/85</subfield><subfield code="2">22</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Powell, Gavin</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Oracle performance tuning for 10gR2</subfield><subfield code="c">Gavin Powell</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">2nd ed</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Burlington, MA</subfield><subfield code="b">Digital Press</subfield><subfield code="c">c2007</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (xlix, 904 p.)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Previous ed. published: New York : Digital Press, c2004, under title: Oracle high performance tuning for 9i and 10g. - Includes index</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">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 in relation to scalability; create a well-proportioned physical architecture at the time of initial Oracle installation; and most important, mix skill sets to obtain the best results. * Fully updated for version 10gR2 and provides all necessary transition material from version 9i * Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning * Contains experienced guidance and real-world examples using large datasets Emphasizes development as opposed to operating system perspective</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Preface -- Introduction -- Part I. Data Model Tuning -- Chapter 1. The Relational Database Model -- Chapter 2. Tuning the Relational Database Model -- Chapter 3. Different Forms of the Relational Database Model -- Chapter 4. A Brief History of Data Modeling -- Part II. SQL Code Tuning -- Chapter 5. What is SQL? -- Chapter 6. Basic Concepts of Efficient SQL -- Chapter 7. Advanced Concepts of Efficient SQL -- Chapter 8. Common Sense Indexing -- Chapter 9. Oracle SQL Optimization and Statistics -- Chapter 10. How Oracle SQL Optimization Works -- Chapter 11. Overriding Optimizer Behavior Using Hints -- Chapter 12. How to Find Problem Queries -- Chapter 13. Automated SQL Tuning -- Part III. Physical and Configuration Tuning -- Chapter 14. Installing Oracle and Creating a Database -- Chapter 15. Tuning Oracle Database File Structures -- Chapter 16. Object Tuning -- Chapter 17. Low Level Physical Tuning -- Chapter 18. Hardware Resource Usage Tuning -- Chapter 19. Tuning Network Usage -- Chapter 20. Oracle Partitioning and Parallelism -- Chapter 21. Ratios: Possible Symptoms of Problems -- Chapter 22. Wait Events -- Chapter 23. Latches -- Chapter 24. Tools and Utilities -- Part IV. Tuning Everything at Once -- Chapter 25. The Wait Event Interface -- Chapter 26. The Database Control -- Chapter 27. Tuning With STATSPACK -- Appendices -- Appendix A. Sample Databases -- Appendix B. Sample Scripts (script changes) -- Appendix C. Sources of Information (accreditations)Appendix D. SQL Tuning in Oracle Enterprise Manager -- (might delete this one, depending on how much I remove from part III, which is 9i)</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">pt. 1. Data model turning -- The relational database model -- Turning the relational database model -- Different forms of the relational database model -- A brief history of data modeling -- pt. 2 SQL code tuning -- What is SQL? -- The basics of efficient SQL -- Advanced concepts of efficient SQL -- Common-sense indexing -- Oracle SQL optimization and statistics -- How Oracle SQL optimization works -- Overriding optimizer behavior using hints -- How to find problem queries -- 10g automated SQL tuning -- pt. 3. Physical and configuration tuning -- Tuning Oracle database file structures -- Object tuning -- Low-level physical tuning -- Hardware resource usage tuning -- Tuning network usage -- Oracle partitioning and parallelism -- pt. 4. Tuning everything at once -- Ratios: possible symptoms of problems -- Wait events -- Latches -- Tools and utilities -- The wait event interface -- 9i tuning with STATSPACK.</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Oracle (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Data Processing</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Oracle (Computer file)</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Relational databases</subfield><subfield code="2">local</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Oracle (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Relational databases</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Powell, Gavin</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=195157</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028469364</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=195157</subfield><subfield code="l">FAW01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FAW_PDA_EBA</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=195157</subfield><subfield code="l">FAW02</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FAW_PDA_EBA</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV043044826 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T07:15:51Z |
| institution | BVB |
| isbn | 0080492029 1555583458 9780080492025 9781555583453 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028469364 |
| oclc_num | 162595444 |
| open_access_boolean | |
| owner | DE-1046 DE-1047 |
| owner_facet | DE-1046 DE-1047 |
| physical | 1 Online-Ressource (xlix, 904 p.) |
| psigel | ZDB-4-EBA ZDB-4-EBA FAW_PDA_EBA |
| publishDate | 2007 |
| publishDateSearch | 2007 |
| publishDateSort | 2007 |
| publisher | Digital Press |
| record_format | marc |
| spelling | Powell, Gavin Verfasser aut Oracle performance tuning for 10gR2 Gavin Powell 2nd ed Burlington, MA Digital Press c2007 1 Online-Ressource (xlix, 904 p.) txt rdacontent c rdamedia cr rdacarrier Previous ed. published: New York : Digital Press, c2004, under title: Oracle high performance tuning for 9i and 10g. - Includes index 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 in relation to scalability; create a well-proportioned physical architecture at the time of initial Oracle installation; and most important, mix skill sets to obtain the best results. * Fully updated for version 10gR2 and provides all necessary transition material from version 9i * Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning * Contains experienced guidance and real-world examples using large datasets Emphasizes development as opposed to operating system perspective Preface -- Introduction -- Part I. Data Model Tuning -- Chapter 1. The Relational Database Model -- Chapter 2. Tuning the Relational Database Model -- Chapter 3. Different Forms of the Relational Database Model -- Chapter 4. A Brief History of Data Modeling -- Part II. SQL Code Tuning -- Chapter 5. What is SQL? -- Chapter 6. Basic Concepts of Efficient SQL -- Chapter 7. Advanced Concepts of Efficient SQL -- Chapter 8. Common Sense Indexing -- Chapter 9. Oracle SQL Optimization and Statistics -- Chapter 10. How Oracle SQL Optimization Works -- Chapter 11. Overriding Optimizer Behavior Using Hints -- Chapter 12. How to Find Problem Queries -- Chapter 13. Automated SQL Tuning -- Part III. Physical and Configuration Tuning -- Chapter 14. Installing Oracle and Creating a Database -- Chapter 15. Tuning Oracle Database File Structures -- Chapter 16. Object Tuning -- Chapter 17. Low Level Physical Tuning -- Chapter 18. Hardware Resource Usage Tuning -- Chapter 19. Tuning Network Usage -- Chapter 20. Oracle Partitioning and Parallelism -- Chapter 21. Ratios: Possible Symptoms of Problems -- Chapter 22. Wait Events -- Chapter 23. Latches -- Chapter 24. Tools and Utilities -- Part IV. Tuning Everything at Once -- Chapter 25. The Wait Event Interface -- Chapter 26. The Database Control -- Chapter 27. Tuning With STATSPACK -- Appendices -- Appendix A. Sample Databases -- Appendix B. Sample Scripts (script changes) -- Appendix C. Sources of Information (accreditations)Appendix D. SQL Tuning in Oracle Enterprise Manager -- (might delete this one, depending on how much I remove from part III, which is 9i) pt. 1. Data model turning -- The relational database model -- Turning the relational database model -- Different forms of the relational database model -- A brief history of data modeling -- pt. 2 SQL code tuning -- What is SQL? -- The basics of efficient SQL -- Advanced concepts of efficient SQL -- Common-sense indexing -- Oracle SQL optimization and statistics -- How Oracle SQL optimization works -- Overriding optimizer behavior using hints -- How to find problem queries -- 10g automated SQL tuning -- pt. 3. Physical and configuration tuning -- Tuning Oracle database file structures -- Object tuning -- Low-level physical tuning -- Hardware resource usage tuning -- Tuning network usage -- Oracle partitioning and parallelism -- pt. 4. Tuning everything at once -- Ratios: possible symptoms of problems -- Wait events -- Latches -- Tools and utilities -- The wait event interface -- 9i tuning with STATSPACK. Oracle (Computer file) COMPUTERS / Data Processing bisacsh Oracle (Computer file) blmlsh Relational databases local Relational databases Powell, Gavin Sonstige oth http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=195157 Aggregator Volltext |
| spellingShingle | Powell, Gavin Oracle performance tuning for 10gR2 Oracle (Computer file) COMPUTERS / Data Processing bisacsh Oracle (Computer file) blmlsh Relational databases local Relational databases |
| title | Oracle performance tuning for 10gR2 |
| title_auth | Oracle performance tuning for 10gR2 |
| title_exact_search | Oracle performance tuning for 10gR2 |
| title_full | Oracle performance tuning for 10gR2 Gavin Powell |
| title_fullStr | Oracle performance tuning for 10gR2 Gavin Powell |
| title_full_unstemmed | Oracle performance tuning for 10gR2 Gavin Powell |
| title_short | Oracle performance tuning for 10gR2 |
| title_sort | oracle performance tuning for 10gr2 |
| topic | Oracle (Computer file) COMPUTERS / Data Processing bisacsh Oracle (Computer file) blmlsh Relational databases local Relational databases |
| topic_facet | Oracle (Computer file) COMPUTERS / Data Processing Relational databases |
| url | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=195157 |
| work_keys_str_mv | AT powellgavin oracleperformancetuningfor10gr2 |