Expert Oracle SQL: Optimization, Deployment, and Statistics
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Berkeley, CA ; s.l.
Apress
2014
Imprint: Apress |
| Schlagworte: | |
| Online-Zugang: | FHM01 FHN01 FKE01 FWS01 FWS02 Volltext Abstract |
| Beschreibung: | Open Access |
| Beschreibung: | 1 Online-Ressource (XXVII, 624 p.) Ill. |
| ISBN: | 9781430259787 |
| DOI: | 10.1007/978-1-4302-5978-7 |
Internformat
MARC
| LEADER | 00000nmm a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV042045947 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 140827s2014 |||| o||u| ||||||eng d | ||
| 020 | |a 9781430259787 |c Online |9 978-1-4302-5978-7 | ||
| 024 | 7 | |a 10.1007/978-1-4302-5978-7 |2 doi | |
| 035 | |a (OCoLC)885793158 | ||
| 035 | |a (DE-599)BVBBV042045947 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-M347 |a DE-92 |a DE-863 |a DE-862 |a DE-859 | ||
| 082 | 0 | |a 004 | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 100 | 1 | |a Hasler, Tony |e Verfasser |0 (DE-588)105697592X |4 aut | |
| 245 | 1 | 0 | |a Expert Oracle SQL |b Optimization, Deployment, and Statistics |c by Tony Hasler |
| 264 | 1 | |a Berkeley, CA ; s.l. |b Apress |c 2014 | |
| 264 | 1 | |b Imprint: Apress | |
| 300 | |a 1 Online-Ressource (XXVII, 624 p.) |b Ill. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 500 | |a Open Access | ||
| 533 | |a Online-Ausgabe |f Springer eBook Collection / Professional and Applied Computing | ||
| 650 | 0 | 7 | |a SQL |0 (DE-588)4134010-3 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a ORACLE |g Datenbanksystem |0 (DE-588)4206222-6 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a ORACLE |g Datenbanksystem |0 (DE-588)4206222-6 |D s |
| 689 | 0 | 1 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |D s |
| 689 | 0 | 2 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 0 | |5 DE-604 | |
| 776 | 0 | 8 | |i Reproduktion von |a Hasler, Tony |t Expert Oracle SQL |d 2014 |
| 776 | 0 | 8 | |i Erscheint auch als |n Druckausgabe |z 978-1-4302-5977-0 |
| 856 | 4 | 0 | |u https://doi.org/10.1007/978-1-4302-5978-7 |x Verlag |3 Volltext |
| 856 | 4 | 2 | |m Springer Fremddatenuebernahme |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027487125&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Abstract |
| 912 | |a ZDB-2-CWD | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-027487125 | ||
| 966 | e | |u https://doi.org/10.1007/978-1-4302-5978-7 |l FHM01 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4302-5978-7 |l FHN01 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4302-5978-7 |l FKE01 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4302-5978-7 |l FWS01 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4302-5978-7 |l FWS02 |p ZDB-2-CWD |x Verlag |3 Volltext | |
Datensatz im Suchindex
| DE-BY-FWS_katkey | 521744 |
|---|---|
| _version_ | 1806179083316363264 |
| adam_text | EXPER T ORACLE SQL
/ HASLER, TONY
: 2014
ABSTRACT / INHALTSTEXT
EXPERT ORACLE SQL: OPTIMIZATION, DEPLOYMENT, AND STATISTICS IS ABOUT
OPTIMIZING INDIVIDUAL SQL STATEMENTS, ESPECIALLY ON PRODUCTION DATABASE
SYSTEMS. THIS ORACLE-SPECIFIC BOOK BEGINS BY ASSUMING YOU HAVE ALREADY
IDENTIFIED A PARTICULAR SQL STATEMENT AND ARE CONSIDERING TAKING STEPS
TO IMPROVE ITS PERFORMANCE. THE BOOK DESCRIBES A SYSTEMATIC PROCESS BY
WHICH TO DIAGNOSE A PROBLEM STATEMENT, IDENTIFY A FIX, AND TO IMPLEMENT
THAT FIX SAFELY IN A PRODUCTION SYSTEM. YOU LL LEARN NOT ONLY TO IMPROVE
PERFORMANCE WHEN IT IS TOO SLOW, BUT ALSO TO STABILIZE PERFORMANCE WHEN
IT IS TOO VARIABLE. YOU LL LEARN ABOUT SYSTEM STATISTICS AND HOW THE
COST-BASED OPTIMIZER USES THEM TO DETERMINE A SUITABLE EXECUTION PLAN
FOR A GIVEN STATEMENT. THAT KNOWLEDGE PROVIDES THE FOUNDATION FROM WHICH
TO IDENTIFY THE ROOT CAUSE, AND TO STABILIZE AND IMPROVE PERFORMANCE.
NEXT AFTER IDENTIFYING A PROBLEM AND THE UNDERLYING ROOT CAUSE IS TO PUT
IN PLACE A SOLUTION. EXPERT ORACLE SQL: OPTIMIZATION, DEPLOYMENT, AND
STATISTICS EXPLAINS HOW TO APPLY VARIOUS REMEDIES SUCH AS CHANGING THE
SQL STATEMENT, ADDING HINTS, CHANGING THE PHYSICAL DESIGN, AND MORE, AND
HOW THEY CAN BE BROUGHT TO BEAR ON FIXING A PROBLEM ONCE AND FOR ALL.
ROLLING A CHANGE OUT SMOOTHLY IS AN IMPORTANT TOPIC WHEN DEALING WITH
TUNING AND OPTIMIZATION. EXPERT ORACLE SQL: OPTIMIZATION, DEPLOYMENT,
AND STATISTICS DOES NOT LET YOU DOWN IN THIS CRITICAL AREA. THE BOOK
CONTAINS TWO CHAPTERS OF GOOD INFORMATION FROM AN EXPERIENCED
PROFESSIONAL ON HOW TO SAFELY DEPLOY CHANGES INTO PRODUCTION SO THAT
YOUR SYSTEMS REMAINING RUNNING AND AVAILABLE THROUGHOUT THE DEPLOYMENT
PROCESS. DESCRIBES A SYSTEMATIC APPROACH TO TUNING ORACLE SQL EXPLAINS
HOW THINGS ARE SUPPOSED TO WORK, WHAT CAN GO WRONG, AND HOW TO FIX IT
TAKES YOU THROUGH THE STEPS NEEDED TO STABILIZE PERFORMANCE IN YOUR
PRODUCTION SYSTEMS
DIESES SCHRIFTSTUECK WURDE MASCHINELL ERZEUGT.
|
| any_adam_object | 1 |
| author | Hasler, Tony |
| author_GND | (DE-588)105697592X |
| author_facet | Hasler, Tony |
| author_role | aut |
| author_sort | Hasler, Tony |
| author_variant | t h th |
| building | Verbundindex |
| bvnumber | BV042045947 |
| classification_rvk | ST 271 |
| collection | ZDB-2-CWD |
| ctrlnum | (OCoLC)885793158 (DE-599)BVBBV042045947 |
| dewey-full | 004 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 004 - Computer science |
| dewey-raw | 004 |
| dewey-search | 004 |
| dewey-sort | 14 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| doi_str_mv | 10.1007/978-1-4302-5978-7 |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02432nmm a2200529 c 4500</leader><controlfield tag="001">BV042045947</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">140827s2014 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781430259787</subfield><subfield code="c">Online</subfield><subfield code="9">978-1-4302-5978-7</subfield></datafield><datafield tag="024" ind1="7" ind2=" "><subfield code="a">10.1007/978-1-4302-5978-7</subfield><subfield code="2">doi</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)885793158</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV042045947</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-M347</subfield><subfield code="a">DE-92</subfield><subfield code="a">DE-863</subfield><subfield code="a">DE-862</subfield><subfield code="a">DE-859</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">004</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Hasler, Tony</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)105697592X</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Expert Oracle SQL</subfield><subfield code="b">Optimization, Deployment, and Statistics</subfield><subfield code="c">by Tony Hasler</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Berkeley, CA ; s.l.</subfield><subfield code="b">Apress</subfield><subfield code="c">2014</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="b">Imprint: Apress</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (XXVII, 624 p.)</subfield><subfield code="b">Ill.</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">Open Access</subfield></datafield><datafield tag="533" ind1=" " ind2=" "><subfield code="a">Online-Ausgabe</subfield><subfield code="f">Springer eBook Collection / Professional and Applied Computing</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ORACLE</subfield><subfield code="g">Datenbanksystem</subfield><subfield code="0">(DE-588)4206222-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">ORACLE</subfield><subfield code="g">Datenbanksystem</subfield><subfield code="0">(DE-588)4206222-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Reproduktion von</subfield><subfield code="a">Hasler, Tony</subfield><subfield code="t">Expert Oracle SQL</subfield><subfield code="d">2014</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druckausgabe</subfield><subfield code="z">978-1-4302-5977-0</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">https://doi.org/10.1007/978-1-4302-5978-7</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Springer Fremddatenuebernahme</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027487125&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Abstract</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-2-CWD</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-027487125</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4302-5978-7</subfield><subfield code="l">FHM01</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4302-5978-7</subfield><subfield code="l">FHN01</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4302-5978-7</subfield><subfield code="l">FKE01</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4302-5978-7</subfield><subfield code="l">FWS01</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4302-5978-7</subfield><subfield code="l">FWS02</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV042045947 |
| illustrated | Illustrated |
| indexdate | 2024-08-01T12:03:22Z |
| institution | BVB |
| isbn | 9781430259787 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-027487125 |
| oclc_num | 885793158 |
| open_access_boolean | |
| owner | DE-M347 DE-92 DE-863 DE-BY-FWS DE-862 DE-BY-FWS DE-859 |
| owner_facet | DE-M347 DE-92 DE-863 DE-BY-FWS DE-862 DE-BY-FWS DE-859 |
| physical | 1 Online-Ressource (XXVII, 624 p.) Ill. |
| psigel | ZDB-2-CWD |
| publishDate | 2014 |
| publishDateSearch | 2014 |
| publishDateSort | 2014 |
| publisher | Apress Imprint: Apress |
| record_format | marc |
| spellingShingle | Hasler, Tony Expert Oracle SQL Optimization, Deployment, and Statistics SQL (DE-588)4134010-3 gnd Datenbankverwaltung (DE-588)4389357-0 gnd ORACLE Datenbanksystem (DE-588)4206222-6 gnd |
| subject_GND | (DE-588)4134010-3 (DE-588)4389357-0 (DE-588)4206222-6 |
| title | Expert Oracle SQL Optimization, Deployment, and Statistics |
| title_auth | Expert Oracle SQL Optimization, Deployment, and Statistics |
| title_exact_search | Expert Oracle SQL Optimization, Deployment, and Statistics |
| title_full | Expert Oracle SQL Optimization, Deployment, and Statistics by Tony Hasler |
| title_fullStr | Expert Oracle SQL Optimization, Deployment, and Statistics by Tony Hasler |
| title_full_unstemmed | Expert Oracle SQL Optimization, Deployment, and Statistics by Tony Hasler |
| title_short | Expert Oracle SQL |
| title_sort | expert oracle sql optimization deployment and statistics |
| title_sub | Optimization, Deployment, and Statistics |
| topic | SQL (DE-588)4134010-3 gnd Datenbankverwaltung (DE-588)4389357-0 gnd ORACLE Datenbanksystem (DE-588)4206222-6 gnd |
| topic_facet | SQL Datenbankverwaltung ORACLE Datenbanksystem |
| url | https://doi.org/10.1007/978-1-4302-5978-7 http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=027487125&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT haslertony expertoraclesqloptimizationdeploymentandstatistics |