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: | 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 |
| Beschreibung: | 1 Online-Ressource (xlix, 904 p.) |
| ISBN: | 9781555583453 1555583458 9780080492025 0080492029 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV042314225 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 150129s2007 |||| o||u| ||||||eng d | ||
| 020 | |a 9781555583453 |9 978-1-55558-345-3 | ||
| 020 | |a 1555583458 |9 1-55558-345-8 | ||
| 020 | |a 9780080492025 |c electronic bk. |9 978-0-08-049202-5 | ||
| 020 | |a 0080492029 |c electronic bk. |9 0-08-049202-9 | ||
| 035 | |a (ZDB-33-EBS)ocn162595444 | ||
| 035 | |a (OCoLC)162595444 | ||
| 035 | |a (DE-599)BVBBV042314225 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1046 | ||
| 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 | ||
| 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 | |
| 653 | |a Electronic books | ||
| 700 | 1 | |a Powell, Gavin |e Sonstige |4 oth | |
| 856 | 4 | 0 | |u http://www.sciencedirect.com/science/book/9781555583453 |x Verlag |3 Volltext |
| 912 | |a ZDB-33-ESD |a ZDB-33-EBS | ||
| 940 | 1 | |q FAW_PDA_ESD | |
| 940 | 1 | |q FLA_PDA_ESD | |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-027751216 | ||
Datensatz im Suchindex
| _version_ | 1804152907167170560 |
|---|---|
| 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 | BV042314225 |
| collection | ZDB-33-ESD ZDB-33-EBS |
| ctrlnum | (ZDB-33-EBS)ocn162595444 (OCoLC)162595444 (DE-599)BVBBV042314225 |
| 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>02833nmm a2200493zc 4500</leader><controlfield tag="001">BV042314225</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">150129s2007 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781555583453</subfield><subfield code="9">978-1-55558-345-3</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">0080492029</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">0-08-049202-9</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-33-EBS)ocn162595444</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)162595444</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV042314225</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></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="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="653" ind1=" " ind2=" "><subfield code="a">Electronic books</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://www.sciencedirect.com/science/book/9781555583453</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-33-ESD</subfield><subfield code="a">ZDB-33-EBS</subfield></datafield><datafield tag="940" ind1="1" ind2=" "><subfield code="q">FAW_PDA_ESD</subfield></datafield><datafield tag="940" ind1="1" ind2=" "><subfield code="q">FLA_PDA_ESD</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-027751216</subfield></datafield></record></collection> |
| id | DE-604.BV042314225 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T01:18:10Z |
| institution | BVB |
| isbn | 9781555583453 1555583458 9780080492025 0080492029 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-027751216 |
| oclc_num | 162595444 |
| open_access_boolean | |
| owner | DE-1046 |
| owner_facet | DE-1046 |
| physical | 1 Online-Ressource (xlix, 904 p.) |
| psigel | ZDB-33-ESD ZDB-33-EBS FAW_PDA_ESD FLA_PDA_ESD |
| 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 Oracle (Computer file) COMPUTERS / Data Processing bisacsh Oracle (Computer file) blmlsh Relational databases local Relational databases Electronic books Powell, Gavin Sonstige oth http://www.sciencedirect.com/science/book/9781555583453 Verlag 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://www.sciencedirect.com/science/book/9781555583453 |
| work_keys_str_mv | AT powellgavin oracleperformancetuningfor10gr2 |