Oracle Performance Tuning for 10gR2, Second Edition

最新推荐文章于 2019-07-08 17:24:07 发布

topmvp

最新推荐文章于 2019-07-08 17:24:07 发布

阅读量422

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle 文章标签： performance oracle scalability transition sql application

本文链接：https://blog.youkuaiyun.com/topmvp/article/details/3356139

Oracle 专栏收录该内容

75 篇文章

订阅专栏

本文探讨了Oracle 10g R2版本中的性能调优策略，包括非规范化数据模型以适应应用程序需求、针对可扩展性的SQL代码调优、创建合理的物理架构及跨技能组合运用等四个方面。强调了数据模型调优、SQL与PL/SQL代码调优及物理配置调优的重要性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

http://rapidshare.com/files/45249302/1555583458.zip
http://depositfiles.com/files/1326576