LEADER 05624nam 2200733 a 450 001 9910808544003321 005 20200520144314.0 010 $a1-283-45344-4 010 $a9786613453440 010 $a1-84968-261-5 035 $a(CKB)2670000000147121 035 $a(EBL)943418 035 $a(OCoLC)796384673 035 $a(SSID)ssj0000647039 035 $a(PQKBManifestationID)11398745 035 $a(PQKBTitleCode)TC0000647039 035 $a(PQKBWorkID)10594019 035 $a(PQKB)10592411 035 $a(WaSeSS)Ind00024357 035 $a(Au-PeEL)EBL943418 035 $a(CaPaEBR)ebr10529547 035 $a(CaONFJC)MIL345344 035 $a(PPN)22803289X 035 $a(OCoLC)795808330 035 $a(OCoLC)ocn795808330 035 $a(FR-PaCSA)88850650 035 $a(CaSebORM)9781849682602 035 $a(MiAaPQ)EBC943418 035 $a(EXLCZ)992670000000147121 100 $a20120303d2012 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aOracle Database 11gR2 performance tuning cookbook $eover 80 recipes to help beginners achieve better performance from Oracle Database applications /$fCiro Fiorillo 205 $a1st edition 210 $aBirmingham, U.K. $cPackt Enterprise$d2012 215 $a1 online resource (543 p.) 300 $aIncludes index. 300 $a"Quick answers to common problems"--Cover. 311 $a1-84968-260-7 320 $aIncludes index. 327 $aCover; 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 327 $aChapter 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 327 $aIndexing 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 327 $aUsing 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 327 $aManaging 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 327 $aTuning the Program Global Area and the User Global Area 330 $aIn 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 606 $aRelational databases 606 $aDatabase management 615 0$aRelational databases. 615 0$aDatabase management. 676 $a005.75/85 676 $a005.7575 700 $aFiorillo$b Ciro$037948 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910808544003321 996 $aOracle Database 11gR2 performance tuning cookbook$94056390 997 $aUNINA