Oracle Database 11gR2 performance tuning cookbook :: over 80 recipes to help beginners achieve better performance from Oracle Database applications /
In this book you will find both examples and theoretical concepts covered. Every recipe is based on a script/procedure explained step-by-step, with screenshots, while theoretical concepts are explained in the context of the recipe, to explain why a solution performs better than another. This book is...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham :
Packt Publishing,
©2012.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | In this book you will find both examples and theoretical concepts covered. Every recipe is based on a script/procedure explained step-by-step, with screenshots, while theoretical concepts are explained in the context of the recipe, to explain why a solution performs better than another. This book is aimed at software developers, software and data architects, and DBAs who are using or are planning to use the Oracle Database, who have some experience and want to solve performance problems faster and in a rigorous way. If you are an architect who wants to design better applications, a DBA who is. |
| Beschreibung: | Includes index. |
| Beschreibung: | 1 online resource (v, 525 pages) |
| ISBN: | 9781849682619 1849682615 |
Internformat
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn775676653 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 120209s2012 enk o 001 0 eng d | ||
| 040 | |a N$T |b eng |e pn |c N$T |d OCLCQ |d OCLCF |d YDXCP |d OCLCQ |d AGLDB |d CNNOR |d U3W |d OCLCQ |d VTS |d OCLCQ |d OCLCO |d NLE |d UKMGB |d OCLCQ |d OCLCO |d STF |d M8D |d UKAHL |d HS0 |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d OCLCL | ||
| 016 | 7 | |a 018015136 |2 Uk | |
| 020 | |a 9781849682619 |q (electronic bk.) | ||
| 020 | |a 1849682615 |q (electronic bk.) | ||
| 035 | |a (OCoLC)775676653 | ||
| 037 | |a 9781849682619 |b Packt Publishing Pvt. Ltd | ||
| 050 | 4 | |a QA76.9.D3 |b F56 2012eb | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 082 | 7 | |a 005.75/6 |2 23 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Fiorillo, Ciro. | |
| 245 | 1 | 0 | |a Oracle Database 11gR2 performance tuning cookbook : |b over 80 recipes to help beginners achieve better performance from Oracle Database applications / |c Ciro Fiorillo. |
| 260 | |a Birmingham : |b Packt Publishing, |c ©2012. | ||
| 300 | |a 1 online resource (v, 525 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 500 | |a Includes index. | ||
| 505 | 0 | |a Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Starting with Performance Tuning; Introduction; Reviewing the performance tuning process; Exploring the example database; Acquiring data using a data dictionary and dynamic performance views; Analyzing data using Statspack reports; Diagnosing performance issues using the alert log; Analyzing data using Automatic Workload Repository (AWR); Analyzing data using Automatic Database Diagnostic Monitor (ADDM); A working example | |
| 505 | 8 | |a Chapter 2: Optimizing Application DesignIntroduction; Optimizing connection management; Improving performance sharing reusable code; Reducing the number of requests to the database using stored procedures; Reducing the number of requests to the database using sequences; Reducing the number of requests to the database using materialized views; Optimizing performance with schema denormalization; Avoiding dynamic SQL; Chapter 3: Optimizing Storage Structures; Introduction; Avoiding row chaining; Avoiding row migration; Using LOBs; Using index clusters; Using hash clusters | |
| 505 | 8 | |a Indexing the correct wayRebuilding index; Compressing indexes; Using reverse key indexes; Using bitmap indexes; Migrating to index organized tables; Using partitioning; Chapter 4: Optimizing SQL Code; Introduction; Using bind variables; Avoiding full table scans; Exploring index lookup; Exploring index skip-scan and index range-scan; Introducing arrays and bulk operations; Optimizing joins; Using subqueries; Tracing SQL activity with SQL Trace and TKPROF; Chapter 5: Optimizing Sort Operations; Introduction; Sorting-in-memory and on-disk; Sorting and indexing; Writing top n queries and ranking | |
| 505 | 8 | |a Using count, min/max, and group-byAvoiding sorting in set operations: union, minus, and intersect; Troubleshooting temporary tablespaces; Chapter 6: Optimizing PL/SQL Code; Introduction; Using bind variables and parsing; Array processing and bulk-collect; Passing values with NOCOPY (or not); Using short-circuit IF statements; Avoiding recursion; Using native compilation; Taking advantage of function result cache; Inlining PL/SQL code; Using triggers and virtual columns; Chapter 7: Improving the Oracle Optimizer; Introduction; Exploring optimizer hints; Collecting statistics; Using histograms | |
| 505 | 8 | |a Managing stored outlinesIntroducing Adaptive Cursor Sharing for bind variable peeking; Creating SQL Tuning Sets; Using the SQL Tuning Advisor; Configuring and using SQL Baselines; Chapter 8: Other Optimizations; Introduction; Caching results with the client-side result cache; Enabling parallel SQL; Direct path inserting; Using create table as select; Inspecting indexes and triggers overhead; Loading data with SQL*Loader and Data Pump; Chapter 9: Tuning Memory; Introduction; Tuning memory to avoid Operating System paging; Tuning the Library Cache; Tuning the Shared Pool | |
| 520 | |a In this book you will find both examples and theoretical concepts covered. Every recipe is based on a script/procedure explained step-by-step, with screenshots, while theoretical concepts are explained in the context of the recipe, to explain why a solution performs better than another. This book is aimed at software developers, software and data architects, and DBAs who are using or are planning to use the Oracle Database, who have some experience and want to solve performance problems faster and in a rigorous way. If you are an architect who wants to design better applications, a DBA who is. | ||
| 630 | 0 | 0 | |a Oracle (Computer file) |0 http://id.loc.gov/authorities/names/n91015760 |
| 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 Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a Relational databases |2 fast | |
| 758 | |i has work: |a Oracle Database 11gR2 performance tuning cookbook (Text) |1 https://id.oclc.org/worldcat/entity/E39PD3FHdcR9fy8fvT4RfHHgXb |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=432013 |3 Volltext |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26944173 | ||
| 938 | |a EBSCOhost |b EBSC |n 432013 | ||
| 938 | |a YBP Library Services |b YANK |n 7425080 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn775676653 |
|---|---|
| _version_ | 1816881785676496896 |
| adam_text | |
| any_adam_object | |
| author | Fiorillo, Ciro |
| author_facet | Fiorillo, Ciro |
| author_role | |
| author_sort | Fiorillo, Ciro |
| author_variant | c f cf |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3 F56 2012eb |
| callnumber-search | QA76.9.D3 F56 2012eb |
| callnumber-sort | QA 276.9 D3 F56 42012EB |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Starting with Performance Tuning; Introduction; Reviewing the performance tuning process; Exploring the example database; Acquiring data using a data dictionary and dynamic performance views; Analyzing data using Statspack reports; Diagnosing performance issues using the alert log; Analyzing data using Automatic Workload Repository (AWR); Analyzing data using Automatic Database Diagnostic Monitor (ADDM); A working example Chapter 2: Optimizing Application DesignIntroduction; Optimizing connection management; Improving performance sharing reusable code; Reducing the number of requests to the database using stored procedures; Reducing the number of requests to the database using sequences; Reducing the number of requests to the database using materialized views; Optimizing performance with schema denormalization; Avoiding dynamic SQL; Chapter 3: Optimizing Storage Structures; Introduction; Avoiding row chaining; Avoiding row migration; Using LOBs; Using index clusters; Using hash clusters Indexing the correct wayRebuilding index; Compressing indexes; Using reverse key indexes; Using bitmap indexes; Migrating to index organized tables; Using partitioning; Chapter 4: Optimizing SQL Code; Introduction; Using bind variables; Avoiding full table scans; Exploring index lookup; Exploring index skip-scan and index range-scan; Introducing arrays and bulk operations; Optimizing joins; Using subqueries; Tracing SQL activity with SQL Trace and TKPROF; Chapter 5: Optimizing Sort Operations; Introduction; Sorting-in-memory and on-disk; Sorting and indexing; Writing top n queries and ranking Using count, min/max, and group-byAvoiding sorting in set operations: union, minus, and intersect; Troubleshooting temporary tablespaces; Chapter 6: Optimizing PL/SQL Code; Introduction; Using bind variables and parsing; Array processing and bulk-collect; Passing values with NOCOPY (or not); Using short-circuit IF statements; Avoiding recursion; Using native compilation; Taking advantage of function result cache; Inlining PL/SQL code; Using triggers and virtual columns; Chapter 7: Improving the Oracle Optimizer; Introduction; Exploring optimizer hints; Collecting statistics; Using histograms Managing stored outlinesIntroducing Adaptive Cursor Sharing for bind variable peeking; Creating SQL Tuning Sets; Using the SQL Tuning Advisor; Configuring and using SQL Baselines; Chapter 8: Other Optimizations; Introduction; Caching results with the client-side result cache; Enabling parallel SQL; Direct path inserting; Using create table as select; Inspecting indexes and triggers overhead; Loading data with SQL*Loader and Data Pump; Chapter 9: Tuning Memory; Introduction; Tuning memory to avoid Operating System paging; Tuning the Library Cache; Tuning the Shared Pool |
| ctrlnum | (OCoLC)775676653 |
| dewey-full | 005.75/6 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/6 |
| dewey-search | 005.75/6 |
| dewey-sort | 15.75 16 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>05684cam a2200529 a 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn775676653</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cnu---unuuu</controlfield><controlfield tag="008">120209s2012 enk o 001 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">N$T</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">N$T</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCF</subfield><subfield code="d">YDXCP</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">AGLDB</subfield><subfield code="d">CNNOR</subfield><subfield code="d">U3W</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">VTS</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">NLE</subfield><subfield code="d">UKMGB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">STF</subfield><subfield code="d">M8D</subfield><subfield code="d">UKAHL</subfield><subfield code="d">HS0</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018015136</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781849682619</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1849682615</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)775676653</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">9781849682619</subfield><subfield code="b">Packt Publishing Pvt. Ltd</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.D3</subfield><subfield code="b">F56 2012eb</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">051170</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.75/6</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Fiorillo, Ciro.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Oracle Database 11gR2 performance tuning cookbook :</subfield><subfield code="b">over 80 recipes to help beginners achieve better performance from Oracle Database applications /</subfield><subfield code="c">Ciro Fiorillo.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Birmingham :</subfield><subfield code="b">Packt Publishing,</subfield><subfield code="c">©2012.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (v, 525 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="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Starting with Performance Tuning; Introduction; Reviewing the performance tuning process; Exploring the example database; Acquiring data using a data dictionary and dynamic performance views; Analyzing data using Statspack reports; Diagnosing performance issues using the alert log; Analyzing data using Automatic Workload Repository (AWR); Analyzing data using Automatic Database Diagnostic Monitor (ADDM); A working example</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Chapter 2: Optimizing Application DesignIntroduction; Optimizing connection management; Improving performance sharing reusable code; Reducing the number of requests to the database using stored procedures; Reducing the number of requests to the database using sequences; Reducing the number of requests to the database using materialized views; Optimizing performance with schema denormalization; Avoiding dynamic SQL; Chapter 3: Optimizing Storage Structures; Introduction; Avoiding row chaining; Avoiding row migration; Using LOBs; Using index clusters; Using hash clusters</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Indexing the correct wayRebuilding index; Compressing indexes; Using reverse key indexes; Using bitmap indexes; Migrating to index organized tables; Using partitioning; Chapter 4: Optimizing SQL Code; Introduction; Using bind variables; Avoiding full table scans; Exploring index lookup; Exploring index skip-scan and index range-scan; Introducing arrays and bulk operations; Optimizing joins; Using subqueries; Tracing SQL activity with SQL Trace and TKPROF; Chapter 5: Optimizing Sort Operations; Introduction; Sorting-in-memory and on-disk; Sorting and indexing; Writing top n queries and ranking</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Using count, min/max, and group-byAvoiding sorting in set operations: union, minus, and intersect; Troubleshooting temporary tablespaces; Chapter 6: Optimizing PL/SQL Code; Introduction; Using bind variables and parsing; Array processing and bulk-collect; Passing values with NOCOPY (or not); Using short-circuit IF statements; Avoiding recursion; Using native compilation; Taking advantage of function result cache; Inlining PL/SQL code; Using triggers and virtual columns; Chapter 7: Improving the Oracle Optimizer; Introduction; Exploring optimizer hints; Collecting statistics; Using histograms</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Managing stored outlinesIntroducing Adaptive Cursor Sharing for bind variable peeking; Creating SQL Tuning Sets; Using the SQL Tuning Advisor; Configuring and using SQL Baselines; Chapter 8: Other Optimizations; Introduction; Caching results with the client-side result cache; Enabling parallel SQL; Direct path inserting; Using create table as select; Inspecting indexes and triggers overhead; Loading data with SQL*Loader and Data Pump; Chapter 9: Tuning Memory; Introduction; Tuning memory to avoid Operating System paging; Tuning the Library Cache; Tuning the Shared Pool</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">In this book you will find both examples and theoretical concepts covered. Every recipe is based on a script/procedure explained step-by-step, with screenshots, while theoretical concepts are explained in the context of the recipe, to explain why a solution performs better than another. This book is aimed at software developers, software and data architects, and DBAs who are using or are planning to use the Oracle Database, who have some experience and want to solve performance problems faster and in a rigorous way. If you are an architect who wants to design better applications, a DBA who is.</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">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">Programming Languages</subfield><subfield code="x">SQL.</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="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">Oracle Database 11gR2 performance tuning cookbook (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PD3FHdcR9fy8fvT4RfHHgXb</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><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=432013</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH26944173</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">432013</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">7425080</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><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-ocn775676653 |
| illustrated | Not Illustrated |
| indexdate | 2024-11-27T13:18:14Z |
| institution | BVB |
| isbn | 9781849682619 1849682615 |
| language | English |
| oclc_num | 775676653 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource (v, 525 pages) |
| psigel | ZDB-4-EBA |
| publishDate | 2012 |
| publishDateSearch | 2012 |
| publishDateSort | 2012 |
| publisher | Packt Publishing, |
| record_format | marc |
| spelling | Fiorillo, Ciro. Oracle Database 11gR2 performance tuning cookbook : over 80 recipes to help beginners achieve better performance from Oracle Database applications / Ciro Fiorillo. Birmingham : Packt Publishing, ©2012. 1 online resource (v, 525 pages) text txt rdacontent computer c rdamedia online resource cr rdacarrier Includes index. Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Starting with Performance Tuning; Introduction; Reviewing the performance tuning process; Exploring the example database; Acquiring data using a data dictionary and dynamic performance views; Analyzing data using Statspack reports; Diagnosing performance issues using the alert log; Analyzing data using Automatic Workload Repository (AWR); Analyzing data using Automatic Database Diagnostic Monitor (ADDM); A working example Chapter 2: Optimizing Application DesignIntroduction; Optimizing connection management; Improving performance sharing reusable code; Reducing the number of requests to the database using stored procedures; Reducing the number of requests to the database using sequences; Reducing the number of requests to the database using materialized views; Optimizing performance with schema denormalization; Avoiding dynamic SQL; Chapter 3: Optimizing Storage Structures; Introduction; Avoiding row chaining; Avoiding row migration; Using LOBs; Using index clusters; Using hash clusters Indexing the correct wayRebuilding index; Compressing indexes; Using reverse key indexes; Using bitmap indexes; Migrating to index organized tables; Using partitioning; Chapter 4: Optimizing SQL Code; Introduction; Using bind variables; Avoiding full table scans; Exploring index lookup; Exploring index skip-scan and index range-scan; Introducing arrays and bulk operations; Optimizing joins; Using subqueries; Tracing SQL activity with SQL Trace and TKPROF; Chapter 5: Optimizing Sort Operations; Introduction; Sorting-in-memory and on-disk; Sorting and indexing; Writing top n queries and ranking Using count, min/max, and group-byAvoiding sorting in set operations: union, minus, and intersect; Troubleshooting temporary tablespaces; Chapter 6: Optimizing PL/SQL Code; Introduction; Using bind variables and parsing; Array processing and bulk-collect; Passing values with NOCOPY (or not); Using short-circuit IF statements; Avoiding recursion; Using native compilation; Taking advantage of function result cache; Inlining PL/SQL code; Using triggers and virtual columns; Chapter 7: Improving the Oracle Optimizer; Introduction; Exploring optimizer hints; Collecting statistics; Using histograms Managing stored outlinesIntroducing Adaptive Cursor Sharing for bind variable peeking; Creating SQL Tuning Sets; Using the SQL Tuning Advisor; Configuring and using SQL Baselines; Chapter 8: Other Optimizations; Introduction; Caching results with the client-side result cache; Enabling parallel SQL; Direct path inserting; Using create table as select; Inspecting indexes and triggers overhead; Loading data with SQL*Loader and Data Pump; Chapter 9: Tuning Memory; Introduction; Tuning memory to avoid Operating System paging; Tuning the Library Cache; Tuning the Shared Pool In this book you will find both examples and theoretical concepts covered. Every recipe is based on a script/procedure explained step-by-step, with screenshots, while theoretical concepts are explained in the context of the recipe, to explain why a solution performs better than another. This book is aimed at software developers, software and data architects, and DBAs who are using or are planning to use the Oracle Database, who have some experience and want to solve performance problems faster and in a rigorous way. If you are an architect who wants to design better applications, a DBA who is. Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) fast Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Bases de données relationnelles. COMPUTERS Programming Languages SQL. bisacsh Relational databases fast has work: Oracle Database 11gR2 performance tuning cookbook (Text) https://id.oclc.org/worldcat/entity/E39PD3FHdcR9fy8fvT4RfHHgXb https://id.oclc.org/worldcat/ontology/hasWork FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=432013 Volltext |
| spellingShingle | Fiorillo, Ciro Oracle Database 11gR2 performance tuning cookbook : over 80 recipes to help beginners achieve better performance from Oracle Database applications / Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Starting with Performance Tuning; Introduction; Reviewing the performance tuning process; Exploring the example database; Acquiring data using a data dictionary and dynamic performance views; Analyzing data using Statspack reports; Diagnosing performance issues using the alert log; Analyzing data using Automatic Workload Repository (AWR); Analyzing data using Automatic Database Diagnostic Monitor (ADDM); A working example Chapter 2: Optimizing Application DesignIntroduction; Optimizing connection management; Improving performance sharing reusable code; Reducing the number of requests to the database using stored procedures; Reducing the number of requests to the database using sequences; Reducing the number of requests to the database using materialized views; Optimizing performance with schema denormalization; Avoiding dynamic SQL; Chapter 3: Optimizing Storage Structures; Introduction; Avoiding row chaining; Avoiding row migration; Using LOBs; Using index clusters; Using hash clusters Indexing the correct wayRebuilding index; Compressing indexes; Using reverse key indexes; Using bitmap indexes; Migrating to index organized tables; Using partitioning; Chapter 4: Optimizing SQL Code; Introduction; Using bind variables; Avoiding full table scans; Exploring index lookup; Exploring index skip-scan and index range-scan; Introducing arrays and bulk operations; Optimizing joins; Using subqueries; Tracing SQL activity with SQL Trace and TKPROF; Chapter 5: Optimizing Sort Operations; Introduction; Sorting-in-memory and on-disk; Sorting and indexing; Writing top n queries and ranking Using count, min/max, and group-byAvoiding sorting in set operations: union, minus, and intersect; Troubleshooting temporary tablespaces; Chapter 6: Optimizing PL/SQL Code; Introduction; Using bind variables and parsing; Array processing and bulk-collect; Passing values with NOCOPY (or not); Using short-circuit IF statements; Avoiding recursion; Using native compilation; Taking advantage of function result cache; Inlining PL/SQL code; Using triggers and virtual columns; Chapter 7: Improving the Oracle Optimizer; Introduction; Exploring optimizer hints; Collecting statistics; Using histograms Managing stored outlinesIntroducing Adaptive Cursor Sharing for bind variable peeking; Creating SQL Tuning Sets; Using the SQL Tuning Advisor; Configuring and using SQL Baselines; Chapter 8: Other Optimizations; Introduction; Caching results with the client-side result cache; Enabling parallel SQL; Direct path inserting; Using create table as select; Inspecting indexes and triggers overhead; Loading data with SQL*Loader and Data Pump; Chapter 9: Tuning Memory; Introduction; Tuning memory to avoid Operating System paging; Tuning the Library Cache; Tuning the Shared Pool Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) fast Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Bases de données relationnelles. COMPUTERS Programming Languages SQL. bisacsh Relational databases fast |
| subject_GND | http://id.loc.gov/authorities/names/n91015760 http://id.loc.gov/authorities/subjects/sh86007768 |
| title | Oracle Database 11gR2 performance tuning cookbook : over 80 recipes to help beginners achieve better performance from Oracle Database applications / |
| title_auth | Oracle Database 11gR2 performance tuning cookbook : over 80 recipes to help beginners achieve better performance from Oracle Database applications / |
| title_exact_search | Oracle Database 11gR2 performance tuning cookbook : over 80 recipes to help beginners achieve better performance from Oracle Database applications / |
| title_full | Oracle Database 11gR2 performance tuning cookbook : over 80 recipes to help beginners achieve better performance from Oracle Database applications / Ciro Fiorillo. |
| title_fullStr | Oracle Database 11gR2 performance tuning cookbook : over 80 recipes to help beginners achieve better performance from Oracle Database applications / Ciro Fiorillo. |
| title_full_unstemmed | Oracle Database 11gR2 performance tuning cookbook : over 80 recipes to help beginners achieve better performance from Oracle Database applications / Ciro Fiorillo. |
| title_short | Oracle Database 11gR2 performance tuning cookbook : |
| title_sort | oracle database 11gr2 performance tuning cookbook over 80 recipes to help beginners achieve better performance from oracle database applications |
| title_sub | over 80 recipes to help beginners achieve better performance from Oracle Database applications / |
| topic | Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760 Oracle (Computer file) fast Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Bases de données relationnelles. COMPUTERS Programming Languages SQL. bisacsh Relational databases fast |
| topic_facet | Oracle (Computer file) Relational databases. Bases de données relationnelles. COMPUTERS Programming Languages SQL. Relational databases |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=432013 |
| work_keys_str_mv | AT fiorillociro oracledatabase11gr2performancetuningcookbookover80recipestohelpbeginnersachievebetterperformancefromoracledatabaseapplications |