Oracle Performance Tuning for 10gR2
Synopsis
Features:
- Fully updated for version iogR2 and provides all necessary transition material from version 91
- 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 data sets.
- Emphasizes development as opposed to operating system perspective
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 SOL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give a 100%+ performance improvement. Physical and configuration tuning often only 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 suit applications; tune SOL 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.
Commander ce livre au
prix de
64,11
€
60,9
€
Classé sous :
Performance,
Code,
Data,
Tuning,
Model