| |||||||||||||||
 Trade In this Item for up to £15.75
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Oracle Performance Survival Guide: A Systematic Approach to Database Optimization (Prentice Hall Professional Oracle) for an Amazon.co.uk gift card of up to £15.75, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
Oracle Performance Survival Guide
A Systematic Approach to Database Optimization
The fast, complete, start-to-finish guide to optimizing Oracle performance
Oracle Performance Survival Guide offers a structured, systematic, start-to-finish methodology for optimizing Oracle performance as efficiently as possible. Leading Oracle expert Guy Harrison shows how to maximize your tuning investment by focusing on causes rather than symptoms, and by quickly identifying the areas that deliver the greatest “bang for the buck.”
Writing for DBAs and developers with all levels of experience, Harrison covers every area of Oracle performance management, from application design through SQL tuning, contention management through memory and physical IO management. He also presents up-to-the-minute guidance for optimizing the performance of the Oracle 11g Release 2.
You’ll start by mastering Oracle structured performance tuning principles and tools, including techniques for tracing and monitoring Oracle execution. Harrison illuminates the interaction between applications and databases, guides you through choosing tuning tools, and introduces upfront design techniques that lead to higher-performance applications. He also presents a collection of downloadable scripts for reporting on all aspects of database performance.
Coverage includes
• “Tuning by layers,” the most effective, highest-value approach to Oracle performance optimization
• Making the most of Oracle’s core tools for tracing, monitoring, and diagnosing performance
• Highly efficient database logical and physical design, indexing, transaction design, and API use
• SQL and PL/SQL tuning, including the use of parallel SQL techniques
• Minimizing contention for locks, latches, shared memory, and other database resources
• Optimizing memory and physical disk IO
• Tuning Real Application Cluster (RAC) databases
guyharrison.net
informit.com/ph
From the Back Cover
Oracle Performance Survival Guide
A Systematic Approach to Database Optimization
The fast, complete, start-to-finish guide to optimizing Oracle performance
Oracle Performance Survival Guide offers a structured, systematic, start-to-finish methodology for optimizing Oracle performance as efficiently as possible. Leading Oracle expert Guy Harrison shows how to maximize your tuning investment by focusing on causes rather than symptoms, and by quickly identifying the areas that deliver the greatest “bang for the buck.”
Writing for DBAs and developers with all levels of experience, Harrison covers every area of Oracle performance management, from application design through SQL tuning, contention management through memory and physical IO management. He also presents up-to-the-minute guidance for optimizing the performance of the Oracle 11g Release 2.
You’ll start by mastering Oracle structured performance tuning principles and tools, including techniques for tracing and monitoring Oracle execution. Harrison illuminates the interaction between applications and databases, guides you through choosing tuning tools, and introduces upfront design techniques that lead to higher-performance applications. He also presents a collection of downloadable scripts for reporting on all aspects of database performance.
Coverage includes
• “Tuning by layers,” the most effective, highest-value approach to Oracle performance optimization
• Making the most of Oracle’s core tools for tracing, monitoring, and diagnosing performance
• Highly efficient database logical and physical design, indexing, transaction design, and API use
• SQL and PL/SQL tuning, including the use of parallel SQL techniques
• Minimizing contention for locks, latches, shared memory, and other database resources
• Optimizing memory and physical disk IO
• Tuning Real Application Cluster (RAC) databases
guyharrison.net
informit.com/ph
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
This book is an encyclopedic overview of all aspects of Oracle performance. Mr. Harrison takes a layered approach, starting at the top with application and data model design where the focus is minimizing the demand for database resources. He then moves down into database code internals, where the focus is maximizing concurrency through reduction of lock, latch, and mutex contention. The next step is to optimize memory usage to minimize the need for physical IO. Finally, he moves to the bottom layer, where the focus is on optimizing physical IO at the disk layer.
Each of these layers is worthy of its own book, so to combine all these topics in a single book is an ambitious goal. Indeed, experienced readers will often want a bit more detail, or wonder why their favorite optimization was not mentioned. However, Mr. Harrison strikes a very good balance between depth and coverage. He also provides a very useful bibliography, including the Oracle documentation, books, and Internet sites and blogs.
For each chapter, Mr. Harrison provides extraordinarily clear, concise, and helpful introductions and summaries. He also uses boxed borders to highlights particularly important points within the text. One can learn a great deal by simply reading these summaries and boxed items, and these can also be used to help the reader find relevant sections, which is especially valuable in a book of this length.
This book is not the last word on SQL tuning, optimizer internals, Oracle troubleshooting, the SGA, nor latch contention. However, its coherent approach, useful summaries and highlights, and efficient organization, make it a valuable and essential guide to anyone wishing to expand their Oracle performance skill set.
The target audience includes both application developers and DBAs. It covers 10g, 11g, 11gR2, with context from 8i and 9i.
This is a real-world book for real working Oracle DBA's, not one of those "theory" books that fill the pages with listings from non-reproducible "test cases".
His systematic approach is very similar to my own, and it was nice to see my own guidelines validated.
At first, I wondered if this was just a plug for the Oracle tools that he sells through his employer, but there is enough fresh content in this book to justify its price!
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
