Guy Harrison, "Oracle Performance Survival Guide: A Systematic Approach to Database Optimization"
Prentice Hall PTR | 2009 | ISBN: 0137011954 | 768 pages | PDF | 6,8 MB
Oracle Performance Survival Guide
A systematic approach for optimizing databases
The rapid and complete from start to finish guide for optimizing the performance of Oracle
Oracle Performance Survival Guide provides a structured, systematic, from beginning to end, the methodology to optimize the performance of Oracle as efficiently as possible. Principal Guy Harrison Oracle expert shows how to maximize your investment in line by focusing on the causes rather than symptoms, and by quickly identifying areas that offer the most "bang for the buck."
Writing for DBAs and developers at all levels of experience, Harrison covers all areas of performance management of Oracle, from designing SQL applications through adjustment, management of claims by the memory management E / S physical. It also features up-to-the-minute orientation to optimize the performance of Oracle 11g Release 2.
Let's start with the domain of structured Oracle performance tuning principles and tools, including techniques for tracking and monitoring the implementation of Oracle. Harrison, illuminates the interaction between applications and databases, guides you through the choice of optimization tools, and introduces initial design techniques that lead to high performance applications. Also features a collection of scripts to download reporting on all aspects of database performance.
Coverage includes
Prentice Hall PTR | 2009 | ISBN: 0137011954 | 768 pages | PDF | 6,8 MB
Oracle Performance Survival Guide
A systematic approach for optimizing databases
The rapid and complete from start to finish guide for optimizing the performance of Oracle
Oracle Performance Survival Guide provides a structured, systematic, from beginning to end, the methodology to optimize the performance of Oracle as efficiently as possible. Principal Guy Harrison Oracle expert shows how to maximize your investment in line by focusing on the causes rather than symptoms, and by quickly identifying areas that offer the most "bang for the buck."
Writing for DBAs and developers at all levels of experience, Harrison covers all areas of performance management of Oracle, from designing SQL applications through adjustment, management of claims by the memory management E / S physical. It also features up-to-the-minute orientation to optimize the performance of Oracle 11g Release 2.
Let's start with the domain of structured Oracle performance tuning principles and tools, including techniques for tracking and monitoring the implementation of Oracle. Harrison, illuminates the interaction between applications and databases, guides you through the choice of optimization tools, and introduces initial design techniques that lead to high performance applications. Also features a collection of scripts to download reporting on all aspects of database performance.
Coverage includes
- "Tuning in layers, the most efficient, highest-value approach to performance optimization of Oracle
- Making the most basic tools for Oracle monitoring, performance monitoring and diagnosis of
- highly efficient database logical and physical design, indexing, design operation and use of the API
- SQL and PL / SQL Tuning, including the use of parallel SQL techniques
- Minimizing contention for locks, latches, shared memory, and database resources
- Optimizing the memory and I / S physical disk
- Tuning Real Application Cluster (RAC) database
