Oracle performance tuning for 10gR2 /:
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 improve...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Burlington, MA :
Digital Press,
©2007.
|
| Ausgabe: | 2nd ed. |
| Schlagworte: | |
| Online-Zugang: | Volltext Volltext |
| Zusammenfassung: | 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. |
| Beschreibung: | 1 online resource (xlix, 904 pages :) |
| ISBN: | 9781555583453 1555583458 9780080492025 0080492029 1281007161 9781281007162 9786611007164 6611007164 |
Internformat
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn162595444 | ||
| 003 | OCoLC | ||
| 005 | 20240705115654.0 | ||
| 006 | m o d | ||
| 007 | cr cn||||||||| | ||
| 008 | 070806s2007 maua o 001 0 eng d | ||
| 010 | |a 2007270274 | ||
| 040 | |a OPELS |b eng |e pn |c OPELS |d OCLCQ |d OCLCO |d OCLCQ |d N$T |d YDXCP |d IDEBK |d DKDLA |d ZCU |d E7B |d UMI |d OCLCO |d DEBSZ |d OCLCQ |d AU@ |d OCLCF |d OCLCQ |d COO |d OCLCQ |d AZK |d JBG |d LOA |d AGLDB |d MOR |d PIFAG |d OCLCQ |d OCLCO |d U3W |d COCUF |d STF |d WRM |d D6H |d OCLCQ |d VTS |d CEF |d INT |d VT2 |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d WYU |d TKN |d LEAUB |d HS0 |d OCLCQ |d OCLCO |d M8D |d OCLCQ |d OCLCO |d OCLCL |d EZC |d UKCRE | ||
| 019 | |a 156908201 |a 488133436 |a 507420514 |a 648305378 |a 824973195 |a 856952088 |a 874199491 |a 961596480 |a 962701020 |a 966182207 |a 988534507 |a 991999681 |a 1034981293 |a 1037790324 |a 1038626824 |a 1055383956 |a 1063815362 |a 1109248195 |a 1153043038 | ||
| 020 | |a 9781555583453 | ||
| 020 | |a 1555583458 | ||
| 020 | |a 9780080492025 |q (electronic bk.) | ||
| 020 | |a 0080492029 |q (electronic bk.) | ||
| 020 | |a 1281007161 | ||
| 020 | |a 9781281007162 | ||
| 020 | |a 9786611007164 | ||
| 020 | |a 6611007164 | ||
| 035 | |a (OCoLC)162595444 |z (OCoLC)156908201 |z (OCoLC)488133436 |z (OCoLC)507420514 |z (OCoLC)648305378 |z (OCoLC)824973195 |z (OCoLC)856952088 |z (OCoLC)874199491 |z (OCoLC)961596480 |z (OCoLC)962701020 |z (OCoLC)966182207 |z (OCoLC)988534507 |z (OCoLC)991999681 |z (OCoLC)1034981293 |z (OCoLC)1037790324 |z (OCoLC)1038626824 |z (OCoLC)1055383956 |z (OCoLC)1063815362 |z (OCoLC)1109248195 |z (OCoLC)1153043038 | ||
| 037 | |a 132716:132837 |b Elsevier Science & Technology |n http://www.sciencedirect.com | ||
| 050 | 4 | |a QA76.9.D3 |b P686 2007eb | |
| 072 | 7 | |a COM |x 018000 |2 bisacsh | |
| 082 | 7 | |a 005.75/85 |2 22 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Powell, Gavin. |0 http://id.loc.gov/authorities/names/n2004004057 | |
| 245 | 1 | 0 | |a Oracle performance tuning for 10gR2 / |c Gavin Powell. |
| 250 | |a 2nd ed. | ||
| 260 | |a Burlington, MA : |b Digital Press, |c ©2007. | ||
| 300 | |a 1 online resource (xlix, 904 pages :) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 520 | |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. | ||
| 505 | 0 | |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). | |
| 505 | 0 | |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. | |
| 588 | 0 | |a Print version record. | |
| 546 | |a English. | ||
| 630 | 0 | 0 | |a Oracle (Computer file) |0 http://id.loc.gov/authorities/names/n91015760 |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 blmlsh |
| 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 Data Processing. |2 bisacsh | |
| 650 | 7 | |a Relational databases |2 fast | |
| 655 | 7 | |a dissertations. |2 aat | |
| 655 | 7 | |a Academic theses |2 fast | |
| 655 | 7 | |a Academic theses. |2 lcgft |0 http://id.loc.gov/authorities/genreForms/gf2014026039 | |
| 655 | 7 | |a Thèses et écrits académiques. |2 rvmgf | |
| 700 | 1 | |a Powell, Gavin. |t Oracle high performance tuning for 9i and 10g. | |
| 758 | |i has work: |a Oracle performance tuning for 10gR2 (Text) |1 https://id.oclc.org/worldcat/entity/E39PCH3GFFBwTBXQRWVhVYY4WP |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Powell, Gavin. |t Oracle performance tuning for 10gR2. |b 2nd ed. |d Burlington, MA : Digital Press, ©2007 |z 1555583458 |z 9781555583453 |w (DLC) 2007270274 |w (OCoLC)72763046 |
| 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=195157 |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=195157 |3 Volltext | |
| 856 | 1 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://www.sciencedirect.com/science/book/9781555583453 |3 Volltext | |
| 856 | 1 | |l CBO01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://www.sciencedirect.com/science/book/9781555583453 |3 Volltext | |
| 938 | |a ebrary |b EBRY |n ebr10186554 | ||
| 938 | |a EBSCOhost |b EBSC |n 195157 | ||
| 938 | |a YBP Library Services |b YANK |n 2599520 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn162595444 |
|---|---|
| _version_ | 1813903303783743489 |
| adam_text | |
| any_adam_object | |
| author | Powell, Gavin |
| author2 | Powell, Gavin |
| author2_role | |
| author2_variant | g p gp |
| author_GND | http://id.loc.gov/authorities/names/n2004004057 |
| author_facet | Powell, Gavin 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 P686 2007eb |
| callnumber-search | QA76.9.D3 P686 2007eb |
| callnumber-sort | QA 276.9 D3 P686 42007EB |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | 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. |
| ctrlnum | (OCoLC)162595444 |
| 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>07326cam a2200697 a 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn162595444</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20240705115654.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cn|||||||||</controlfield><controlfield tag="008">070806s2007 maua o 001 0 eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a"> 2007270274</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">OPELS</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">OPELS</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">N$T</subfield><subfield code="d">YDXCP</subfield><subfield code="d">IDEBK</subfield><subfield code="d">DKDLA</subfield><subfield code="d">ZCU</subfield><subfield code="d">E7B</subfield><subfield code="d">UMI</subfield><subfield code="d">OCLCO</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">AU@</subfield><subfield code="d">OCLCF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">COO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">AZK</subfield><subfield code="d">JBG</subfield><subfield code="d">LOA</subfield><subfield code="d">AGLDB</subfield><subfield code="d">MOR</subfield><subfield code="d">PIFAG</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">U3W</subfield><subfield code="d">COCUF</subfield><subfield code="d">STF</subfield><subfield code="d">WRM</subfield><subfield code="d">D6H</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">VTS</subfield><subfield code="d">CEF</subfield><subfield code="d">INT</subfield><subfield code="d">VT2</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">WYU</subfield><subfield code="d">TKN</subfield><subfield code="d">LEAUB</subfield><subfield code="d">HS0</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">OCLCL</subfield><subfield code="d">EZC</subfield><subfield code="d">UKCRE</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">156908201</subfield><subfield code="a">488133436</subfield><subfield code="a">507420514</subfield><subfield code="a">648305378</subfield><subfield code="a">824973195</subfield><subfield code="a">856952088</subfield><subfield code="a">874199491</subfield><subfield code="a">961596480</subfield><subfield code="a">962701020</subfield><subfield code="a">966182207</subfield><subfield code="a">988534507</subfield><subfield code="a">991999681</subfield><subfield code="a">1034981293</subfield><subfield code="a">1037790324</subfield><subfield code="a">1038626824</subfield><subfield code="a">1055383956</subfield><subfield code="a">1063815362</subfield><subfield code="a">1109248195</subfield><subfield code="a">1153043038</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781555583453</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1555583458</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780080492025</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0080492029</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1281007161</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781281007162</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9786611007164</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">6611007164</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)162595444</subfield><subfield code="z">(OCoLC)156908201</subfield><subfield code="z">(OCoLC)488133436</subfield><subfield code="z">(OCoLC)507420514</subfield><subfield code="z">(OCoLC)648305378</subfield><subfield code="z">(OCoLC)824973195</subfield><subfield code="z">(OCoLC)856952088</subfield><subfield code="z">(OCoLC)874199491</subfield><subfield code="z">(OCoLC)961596480</subfield><subfield code="z">(OCoLC)962701020</subfield><subfield code="z">(OCoLC)966182207</subfield><subfield code="z">(OCoLC)988534507</subfield><subfield code="z">(OCoLC)991999681</subfield><subfield code="z">(OCoLC)1034981293</subfield><subfield code="z">(OCoLC)1037790324</subfield><subfield code="z">(OCoLC)1038626824</subfield><subfield code="z">(OCoLC)1055383956</subfield><subfield code="z">(OCoLC)1063815362</subfield><subfield code="z">(OCoLC)1109248195</subfield><subfield code="z">(OCoLC)1153043038</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">132716:132837</subfield><subfield code="b">Elsevier Science & Technology</subfield><subfield code="n">http://www.sciencedirect.com</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.D3</subfield><subfield code="b">P686 2007eb</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">018000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.75/85</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 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="260" ind1=" " ind2=" "><subfield code="a">Burlington, MA :</subfield><subfield code="b">Digital Press,</subfield><subfield code="c">©2007.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (xlix, 904 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="520" 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="505" ind1="0" 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="505" ind1="0" 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="588" ind1="0" ind2=" "><subfield code="a">Print version record.</subfield></datafield><datafield tag="546" ind1=" " ind2=" "><subfield code="a">English.</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">blmlsh</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">Data Processing.</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="655" ind1=" " ind2="7"><subfield code="a">dissertations.</subfield><subfield code="2">aat</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Academic theses</subfield><subfield code="2">fast</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Academic theses.</subfield><subfield code="2">lcgft</subfield><subfield code="0">http://id.loc.gov/authorities/genreForms/gf2014026039</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Thèses et écrits académiques.</subfield><subfield code="2">rvmgf</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Powell, Gavin.</subfield><subfield code="t">Oracle high performance tuning for 9i and 10g.</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">Oracle performance tuning for 10gR2 (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCH3GFFBwTBXQRWVhVYY4WP</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 performance tuning for 10gR2.</subfield><subfield code="b">2nd ed.</subfield><subfield code="d">Burlington, MA : Digital Press, ©2007</subfield><subfield code="z">1555583458</subfield><subfield code="z">9781555583453</subfield><subfield code="w">(DLC) 2007270274</subfield><subfield code="w">(OCoLC)72763046</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=195157</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=195157</subfield><subfield code="3">Volltext</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://www.sciencedirect.com/science/book/9781555583453</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://www.sciencedirect.com/science/book/9781555583453</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ebrary</subfield><subfield code="b">EBRY</subfield><subfield code="n">ebr10186554</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">195157</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">2599520</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> |
| genre | dissertations. aat Academic theses fast Academic theses. lcgft http://id.loc.gov/authorities/genreForms/gf2014026039 Thèses et écrits académiques. rvmgf |
| genre_facet | dissertations. Academic theses Academic theses. Thèses et écrits académiques. |
| id | ZDB-4-EBA-ocn162595444 |
| illustrated | Illustrated |
| indexdate | 2024-10-25T16:16:33Z |
| institution | BVB |
| isbn | 9781555583453 1555583458 9780080492025 0080492029 1281007161 9781281007162 9786611007164 6611007164 |
| language | English |
| lccn | 2007270274 |
| oclc_num | 162595444 |
| open_access_boolean | |
| owner | MAIN |
| owner_facet | MAIN |
| physical | 1 online resource (xlix, 904 pages :) |
| psigel | ZDB-4-EBA |
| publishDate | 2007 |
| publishDateSearch | 2007 |
| publishDateSort | 2007 |
| publisher | Digital Press, |
| record_format | marc |
| spelling | Powell, Gavin. http://id.loc.gov/authorities/names/n2004004057 Oracle performance tuning for 10gR2 / Gavin Powell. 2nd ed. Burlington, MA : Digital Press, ©2007. 1 online resource (xlix, 904 pages :) text txt rdacontent computer c rdamedia online resource cr rdacarrier 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. Print version record. English. Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) blmlsh Oracle (Computer file) fast Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Bases de données relationnelles. COMPUTERS Data Processing. bisacsh Relational databases fast dissertations. aat Academic theses fast Academic theses. lcgft http://id.loc.gov/authorities/genreForms/gf2014026039 Thèses et écrits académiques. rvmgf Powell, Gavin. Oracle high performance tuning for 9i and 10g. has work: Oracle performance tuning for 10gR2 (Text) https://id.oclc.org/worldcat/entity/E39PCH3GFFBwTBXQRWVhVYY4WP https://id.oclc.org/worldcat/ontology/hasWork Print version: Powell, Gavin. Oracle performance tuning for 10gR2. 2nd ed. Burlington, MA : Digital Press, ©2007 1555583458 9781555583453 (DLC) 2007270274 (OCoLC)72763046 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=195157 Volltext CBO01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=195157 Volltext FWS01 ZDB-4-EBA FWS_PDA_EBA https://www.sciencedirect.com/science/book/9781555583453 Volltext CBO01 ZDB-4-EBA FWS_PDA_EBA https://www.sciencedirect.com/science/book/9781555583453 Volltext |
| spellingShingle | Powell, Gavin Oracle performance tuning for 10gR2 / 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) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) blmlsh Oracle (Computer file) fast Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Bases de données relationnelles. COMPUTERS Data Processing. bisacsh Relational databases fast |
| subject_GND | http://id.loc.gov/authorities/names/n91015760 http://id.loc.gov/authorities/subjects/sh86007768 http://id.loc.gov/authorities/genreForms/gf2014026039 |
| title | Oracle performance tuning for 10gR2 / |
| title_alt | Oracle high performance tuning for 9i and 10g. |
| 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) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) blmlsh Oracle (Computer file) fast Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Bases de données relationnelles. COMPUTERS Data Processing. bisacsh Relational databases fast |
| topic_facet | Oracle (Computer file) Relational databases. Bases de données relationnelles. COMPUTERS Data Processing. Relational databases dissertations. Academic theses Academic theses. Thèses et écrits académiques. |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=195157 https://www.sciencedirect.com/science/book/9781555583453 |
| work_keys_str_mv | AT powellgavin oracleperformancetuningfor10gr2 |