Series: Expert's Voice in Oracle
Hardcover: 586 pages
Publisher: Apress; 1st ed. edition (June 23, 2008)
Product Dimensions: 7 x 1.4 x 10 inches
Shipping Weight: 2.5 pounds (View shipping rates and policies)
Average Customer Review: 4.6 out of 5 stars See all reviews (8 customer reviews)
Best Sellers Rank: #1,604,983 in Books (See Top 100 in Books) #104 in Books > Computers & Technology > Databases & Big Data > Relational Databases #390 in Books > Computers & Technology > Databases & Big Data > Oracle #1484 in Books > Textbooks > Computer Science > Database Storage & Design
"Troubleshooting Oracle Performance" is the most thorough, yet physically compact book covering performance tuning with Oracle 9i R2 through 11g R1 on the market. It is quite clear that a great deal of effort was made by the author to carefully verify the tips and test results contained in the book and to organize the material in a logical progression, thus building a bridge between the reader's current understanding to the understanding of complex tuning approaches.What this book accomplishes, which most other performance tuning books seem to miss, is to indicate which performance tuning features are available in each Oracle release (and which are available at no additional licensing cost) as the various performance tuning approaches are discussed. Not only does the book indicate when a feature would be appropriate, but also potential problems ("Pitfalls and Fallacies") associated with each feature.The depth of coverage of Oracle 11g R1 features is surprisingly thorough given the short amount of time which that version has been on the market. A little more detail in a couple areas, such as hacking stored outlines, would have been helpful; at the same time, everyone who reads the book might have a different opinion of what needed additional detail, the book could have grown to 2500 or more pages, and likely would have been obsolete by the time it was published.The Apress Roadmap on the back cover of the book indicates that this book should be read before "Forecasting Oracle Performance", "Expert Oracle Database Architecture", and "Cost-Based Oracle Fundamentals". The "Troubleshooting Oracle Performance" book seems to assume that the Oracle database concepts are well understood.
The author Christian Antognini has done a wonderful job in writing a great book on how to systematically analyze issues with Oracle 11g. Let's be honest, Oracle 11g is a beast and take a very long time to master all areas of its core functionality. I have been using Oracle for only a few years and I sometime still consider myself a newbie.The recent version of 11g has added lots of new functionality such as database replay, sql access advisor, sucurefiles, flashback data archiving, tablespace encryption, data masking and so much more. IT sometimes feels that version 11g is a totally new database compared to version 10.x.The great thing about this book which others fail is that it covers all versions of Oracle from version 9i to 11gR1. So even if you are using an older version this book still is extremely valuable to own. It will actually save you money if you are using an older version of Oracle because it can be used as you gradually upgrade to newer versions of Oracle. Another reason to buy it!This book assumes that you already have a good knowledge of using Oracle and goes right into many different scenarios of using different front-end technologies where performance issues can happen and hot to step-by-step figure out where your problem may be coming from.The author focuses on tracing database calls, profiling PL/SQL code, how to review workload statistics and object statistics, how to configure your query optimizer, and one of the most useful sections of the book is Chapter 6 where the author focus on many different execution plans. I also liked Chapter 10 where the author goes through all the different types of SQL commands (joins, nested loops, merge joins, hash joins, etc.) and how they can be improved and optimized.
Deeper Voice: Get a Deeper voice Quickly, Become a Leader: Proven way to deepen your voice:(Low pitched voice, Attractive Voice, Voice Singers, Manly Voice, Charisma, Power) Troubleshooting Oracle Performance (Expert's Voice in Oracle) Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution (Oracle Press) Beginning Oracle Database 11g Administration: From Novice to Professional (Expert's Voice in Oracle) Windows 10 Troubleshooting: Windows 10 Manuals, Display Problems, Sound Problems, Drivers and Software: Windows 10 Troubleshooting: How to Fix Common Problems ... Tips and Tricks, Optimize Windows 10) Easy Thermostat Wiring & Troubleshooting Guide: Simple HVAC, Furnace, and Air Conditioning; Thermostat Wiring and Troubleshooting Guide for Homeowners (HelpItBroke.com - Easy HVAC Guides Book 3) Outboard Engines: Maintenance, Troubleshooting, and Repair, Second Edition: Maintenance, Troubleshooting, and Repair Oracle Performance Survival Guide: A Systematic Approach to Database Optimization (Prentice Hall Professional Oracle Series) Expert Visual C++/CLI: .NET for Visual C++ Programmers (Expert's Voice in .NET) Computer Repair with Diagnostic Flowcharts Third Edition: Troubleshooting PC Hardware Problems from Boot Failure to Poor Performance Computer Repair with Diagnostic Flowcharts: Troubleshooting PC Hardware Problems from Boot Failure to Poor Performance, Revised Edition Carrier Grade Voice Over IP (McGraw-Hill Networking Professional Carrier Grade Voice Over IP Second Edition) Soirees Musicales (for Voice & Piano), Nos. 1-8, Vol 1: High Voice (French, Italian Language Edition), Octavo-Size Book (Kalmus Edition) (French Edition) Franz Schubert - 15 Selected Songs (High Voice): The Vocal Library - High Voice Schumann Songs German Lieder For High Voice Book/CD (Music Minus One High Voice) Art Song in English - 50 Songs by 21 American and British Composers: High Voice (BH Voice) Manon: A Performance Guide (Vox Musicae the Voice, Vocal Pedagogy, and Song; No 7) Werther:A Performance Guide (Vox Musicae: the Voice, Vocal Pedagogy and Song) Performance Dog Nutrition - Optimize Performance With Nutrition Performance Anxiety Cure: How To Overcome Performance Anxiety And Stage Fright In All Aspects Of Life Forever (anxiety recovery, panic attacks, anxiety management, anxiety attacks)