It's Raining Books Sale

Recently Viewed clear list

Original Essays | September 15, 2014

Lois Leveen: IMG Forsooth Me Not: Shakespeare, Juliet, Her Nurse, and a Novel

There's this writer, William Shakespeare. Perhaps you've heard of him. He wrote this play, Romeo and Juliet. Maybe you've heard of it as well. It's... Continue »
  1. $18.19 Sale Hardcover add to wish list

    Juliet's Nurse

    Lois Leveen 9781476757445


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

Other titles in the Prentice Hall Professional Oracle series:

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 (

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
Follow us on...

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