Cargando…
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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing,
©2012.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | EBSCO_ocn775676653 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.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 | ||
| 016 | 7 | |a 018015136 |2 Uk | |
| 020 | |a 9781849682619 |q (electronic bk.) | ||
| 020 | |a 1849682615 |q (electronic bk.) | ||
| 029 | 1 | |a DEBBG |b BV043151221 | |
| 029 | 1 | |a DEBSZ |b 421454458 | |
| 029 | 1 | |a GBVCP |b 803887957 | |
| 029 | 1 | |a UKMGB |b 018015136 | |
| 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 | 0 | 4 | |a 005.75/6 |2 23 |
| 049 | |a UAMI | ||
| 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. | ||
| 590 | |a eBooks on EBSCOhost |b EBSCO eBook Subscription Academic Collection - Worldwide | ||
| 630 | 0 | 0 | |a Oracle (Computer file) |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 fast |
| 650 | 0 | |a Relational databases. | |
| 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 | |
| 856 | 4 | 0 | |u https://ebsco.uam.elogim.com/login.aspx?direct=true&scope=site&db=nlebk&AN=432013 |z Texto completo |
| 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 IZTAP | ||