Poetry Madness

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores

    Recently Viewed clear list

    Interviews | March 9, 2015

    Rhianna Walton: IMG Erik Larson: The Powells.com Interview

    Erik LarsonI've been a fan of Erik Larson's riveting brand of narrative history for years, and his latest book, Dead Wake: The Last Crossing of the Lusitania,... Continue »
    1. $19.60 Sale Hardcover add to wish list


On Order

New Trade Paper
Currently out of stock.
Add to Wishlist
available for shipping or prepaid pickup only
Qty Store Section
- Local Warehouse Database- Design

Oracle Performance Survival Guide: A Systematic Approach to Database Optimization (Prentice Hall Professional Oracle)


Oracle Performance Survival Guide: A Systematic Approach to Database Optimization (Prentice Hall Professional Oracle) Cover


Synopses & Reviews

Publisher Comments:

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







Book News Annotation:

Harrison (Quest Software) outlines a tuning methodology for identifying the root causes of Oracle performance problems, and provides a collection of downloadable scripts for reporting all aspects of database performance. Separate layers apply techniques for minimizing application workload, reducing contention and bottlenecks, adjusting buffer cache and PGA memory, and optimizing disk IO. Topics include indexing and clustering, execution plan management, tuning table access, joins and subqueries, sorting and grouping, parallel SQL, lock contention, and real application cluster databases. Annotation ©2010 Book News, Inc., Portland, OR (booknews.com)

About the Author

Guy Harrison is Chief Architect for Database Solutions at Quest Software, where he leads a software development team that created the popular Spotlight family of products and is responsible for Spotlight on Oracle, Spotlight on Oracle RAC, Spotlight on MySQL, and Spotlight on SQL. A recognized Oracle expert, he has almost two decades experience in application and database administration, performance tuning and software development. His books include Oracle SQL High Performance Tuning, Oracle Desk Reference, and MySQL Stored Procedure Programming. A regular speaker at database events, he also writes a monthly column for Database Trends and Applications.

Table of Contents

Part I: Methodology and Tools

Part II: Optimizing the Application

Part III: Eliminating contention

Part IV: Optimizing memory to minimize disk IO

Part V: Tuning Physical IO

Product Details

Harrison, Guy
Prentice Hall PTR
Database Management - General
Database management
Database design
Edition Description:
Trade paper
Prentice Hall Professional Oracle Series
Publication Date:
October 2009
Grade Level:
Professional and scholarly
9.1 x 6.9 x 1.4 in 1211 gr

Related Subjects

Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Software Management

Oracle Performance Survival Guide: A Systematic Approach to Database Optimization (Prentice Hall Professional Oracle) New Trade Paper
0 stars - 0 reviews
$72.50 Backorder
Product details 768 pages Prentice Hall PTR - English 9780137011957 Reviews:
  • back to top


Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.