Oracle Performance Survival Guide: A Systematic Approach to Database Optimization - Brossura

Harrison, Guy

Brossura

ISBN 10: 0137011954 ISBN 13: 9780137011957

Casa editrice: Prentice Hall, 2009

Riassunto

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

 

 

 

Su questo libro

Informazioni sull?autore

Guy Harrisonhas worked with Oracle databases as a developer, administrator, and performance expert for more than two decades. He is the author of many articles and several books on database technology, including Oracle SQL High Performance Tuning(Prentice Hall) and MySql Stored Procedure Programming(with Steven Feuerstein, O’Reilly). Guy is currently a director of development at Quest Software and is the chief architect of Quest’s popular Spotlight product family. He lives in Melbourne, Australia, with his wife Jenni and children Chris, Kate, Mike, and William. You can find Guy on the Web at http://www.guyharrison.net

Dettagli dell'edizione

• Editore: Prentice Hall
• Data di pubblicazione: 2009
• Lingua: Inglese
• ISBN 10: 0137011954
• ISBN 13: 9780137011957
• Rilegatura: Copertina flessibile
• Numero edizione: 1
• Numero di pagine: 760
• Contatto del produttore: non disponibile
• Persona responsabile: Yeepin GmbH; 492000000000; sunshine12232@outlook.com; ; Alleestr.11; Kaiserslautern; Rheinland-Pfalz; 67655; Germania