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
Elsevier Science
2011
|
| Ausgabe: | 2nd ed |
| Schlagworte: | |
| 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: | Description based on publisher supplied metadata and other sources |
| Beschreibung: | 1 online resource (955 pages) |
| ISBN: | 9780080492025 9781555583453 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV044049399 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 170217s2011 |||| o||u| ||||||eng d | ||
| 020 | |a 9780080492025 |9 978-0-08-049202-5 | ||
| 020 | |a 9781555583453 |c Print |9 978-1-55558-345-3 | ||
| 035 | |a (ZDB-30-PAD)EBC294647 | ||
| 035 | |a (ZDB-89-EBL)EBL294647 | ||
| 035 | |a (ZDB-38-EBR)ebr10186554 | ||
| 035 | |a (OCoLC)437181621 | ||
| 035 | |a (DE-599)BVBBV044049399 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 082 | 0 | |a 005.7585 | |
| 100 | 1 | |a Powell, Gavin JT. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Oracle Performance Tuning for 10gR2 |
| 250 | |a 2nd ed | ||
| 264 | 1 | |a Burlington |b Elsevier Science |c 2011 | |
| 264 | 4 | |c © 2007 | |
| 300 | |a 1 online resource (955 pages) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 500 | |a Description based on publisher supplied metadata and other sources | ||
| 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 | ||
| 650 | 4 | |a Relational databases | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |a Powell, Gavin JT |t Oracle Performance Tuning for 10gR2 |
| 912 | |a ZDB-30-PAD |a ZDB-38-ESG | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-029456244 | ||
Datensatz im Suchindex
| _version_ | 1804177065824485376 |
|---|---|
| any_adam_object | |
| author | Powell, Gavin JT |
| author_facet | Powell, Gavin JT |
| author_role | aut |
| author_sort | Powell, Gavin JT |
| author_variant | g j p gj gjp |
| building | Verbundindex |
| bvnumber | BV044049399 |
| collection | ZDB-30-PAD ZDB-38-ESG |
| ctrlnum | (ZDB-30-PAD)EBC294647 (ZDB-89-EBL)EBL294647 (ZDB-38-EBR)ebr10186554 (OCoLC)437181621 (DE-599)BVBBV044049399 |
| dewey-full | 005.7585 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.7585 |
| dewey-search | 005.7585 |
| dewey-sort | 15.7585 |
| 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>02369nmm a2200385zc 4500</leader><controlfield tag="001">BV044049399</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">170217s2011 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780080492025</subfield><subfield code="9">978-0-08-049202-5</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781555583453</subfield><subfield code="c">Print</subfield><subfield code="9">978-1-55558-345-3</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-30-PAD)EBC294647</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-89-EBL)EBL294647</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-38-EBR)ebr10186554</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)437181621</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV044049399</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.7585</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Powell, Gavin JT.</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></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">2nd ed</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Burlington</subfield><subfield code="b">Elsevier Science</subfield><subfield code="c">2011</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">© 2007</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (955 pages)</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">Description based on publisher supplied metadata and other sources</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="650" ind1=" " ind2="4"><subfield code="a">Relational databases</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="a">Powell, Gavin JT</subfield><subfield code="t">Oracle Performance Tuning for 10gR2</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-PAD</subfield><subfield code="a">ZDB-38-ESG</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-029456244</subfield></datafield></record></collection> |
| id | DE-604.BV044049399 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T07:42:09Z |
| institution | BVB |
| isbn | 9780080492025 9781555583453 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-029456244 |
| oclc_num | 437181621 |
| open_access_boolean | |
| physical | 1 online resource (955 pages) |
| psigel | ZDB-30-PAD ZDB-38-ESG |
| publishDate | 2011 |
| publishDateSearch | 2011 |
| publishDateSort | 2011 |
| publisher | Elsevier Science |
| record_format | marc |
| spelling | Powell, Gavin JT. Verfasser aut Oracle Performance Tuning for 10gR2 2nd ed Burlington Elsevier Science 2011 © 2007 1 online resource (955 pages) txt rdacontent c rdamedia cr rdacarrier Description based on publisher supplied metadata and other sources 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 Relational databases Erscheint auch als Druck-Ausgabe Powell, Gavin JT Oracle Performance Tuning for 10gR2 |
| spellingShingle | Powell, Gavin JT Oracle Performance Tuning for 10gR2 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 |
| title_fullStr | Oracle Performance Tuning for 10gR2 |
| title_full_unstemmed | Oracle Performance Tuning for 10gR2 |
| title_short | Oracle Performance Tuning for 10gR2 |
| title_sort | oracle performance tuning for 10gr2 |
| topic | Relational databases |
| topic_facet | Relational databases |
| work_keys_str_mv | AT powellgavinjt oracleperformancetuningfor10gr2 |