Oracle Performance Tuning for 10gR2, Second Edition
|
| |
ISBN |
1555583458 |
|
Release Date |
15 September 2006 |
|
Category |
Oracle |
|
Tags |
oracle, tuning, oracle 10g, 10g, performance, oracle tuning, performance tuning, "performance tuning, 10gr2, oracle 11g, pl/sql tuning, oracle performance tuning, gavin powel, oracle + best practices, oracle designing and tuning for performance, 1555583458, oracle financials, oracle tuning, "oracle performance", "oracle performance tuning", rman, oracle statspack, oracle and tuning,
|
|
This book @Amazon |
View |
|
Description
Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100% performance improvement. Physical and configuration tuning often gives at most a 25% performance increase.
Gavin Powell shows that the central theme of Oracle10gR2 Performance Tuning is four-fold: denormalize data models to fit applications; tune SQL code according to both the data model and the application in relation to scalability; create a well-proportioned physical architecture at the time of initial Oracle installation; and most important, mix skill sets to obtain the best results.
* Fully updated for version 10gR2 and provides all necessary transition material from version 9i * Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning * Contains experienced guidance and real-world examples using large datasets Emphasizes development as opposed to operating system perspective |
|