Oracle performance tuning for 10gR2

Gespeichert in:
Bibliographische Detailangaben
1. Verfasser: Powell, Gavin (VerfasserIn)
Format: Elektronisch E-Book
Sprache:English
Veröffentlicht: Burlington, MA Digital Press c2007
Ausgabe:2nd ed
Schlagworte:
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!

MARC

LEADER 00000nam a2200000zc 4500
001 BV042314225
003 DE-604
005 00000000000000.0
007 cr|uuu---uuuuu
008 150129s2007 xx o|||| 00||| 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 
912 |a ZDB-33-EBS 
940 1 |q FAW_PDA_ESD 
940 1 |q FLA_PDA_ESD 
943 1 |a oai:aleph.bib-bvb.de:BVB01-027751216 

Datensatz im Suchindex

_version_ 1819294031118598145
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>02848nam a2200505zc 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 xx o|||| 00||| 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 &amp; 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></datafield><datafield tag="912" ind1=" " ind2=" "><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="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-027751216</subfield></datafield></record></collection>
id DE-604.BV042314225
illustrated Not Illustrated
indexdate 2024-12-24T04:19:48Z
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