对Oracle数据库调优性能浓厚的朋友肯定没有错过TUSC著名的Richard Niemiec的<Oracle Database 9i/10g Performance Tuning & Tips & Techniques> ,这2本书目前有中文译版; 这2本书包含了 Richard Niemiec 丰富的Oracle Database 调优经验、详细的案例研究。 Richard Niemiec是一名世界顶尖的Oracle优化专家,同时他也是一位Oracle认证的管理大师OCM, 他的书为优化人员提供了大量的提示和技巧:
随着10g 版本正式进入Sustaining Support, 12c R1版本可能在12年末、13年初release , 现在正是 11g Release 2开始在国内大范围推广使用的时段。
如果你现在对 11g 的Tuning 新特性还不甚了解,包括如:adaptive Cursor Sharing、Result Cache、SQL Performance Analayze …. 。 你完全需要一本 11g 调优的完全指南, 而 Richard Niemiec 的 <Oracle Database 11g Release 2 Performance Tuning Tips & Techniques> 就是这样一本好书, 奉上封面和章节目录, 虽然这本书目前还没有中译版,但是相信很快可见:
· Chapter 1 11g R1 & R2 New Features: Rewritten completely for basic Oracle11gR2 new features
· Chapter 2 Basic Index Principles: Expanded to cover all of the index types and tested for 11gR2
· Chapter 3 Disk Implementation: Updated for 11gR2: ASM, LMT, Auto UNDO, and improved I/O sections
· Chapter 4 Initialization Parameters: Added MEMORY_TARGET and updated parameters for 11gR2
· Chapter 5 Enterprise Manager & Grid Control: Added 11g screen shots, Grid Control, and some Exadata
· Chapter 6 Explain Plan, SQL Plan Management, DBMS_MONITOR, and TRCSESS
· Chapter 7 Using Hints for Tuning: Added new hints and updated others—the best resource for hints!
· Chapter 8 Basic Query Tuning: Updated for 11gR2; added Result Cache and SQL Performance Analyzer
· Chapter 9 Table Joins & Advanced Tuning: Updated for 11gR2; updated block tuning and added DB Replay
· Chapter 10 PL/SQL Tuning: Expanded again as PL/SQL tuning expands; added 11gR2 changes
· Chapter 11 Exadata, RAC, & Parallel Features: Added Exadata, improved RAC, & updated Parallel Query
· Chapter 12 The V$ Views: Expanded again to show more V$ view queries, especially those new in 11gR2
· Chapter 13 The X$ Tables: Expanded X$ queries, trace section, and X$ naming conventions
· Chapter 14 AWR Report & Statspack: Updated AWR, Statspack for 11gR2; added mutexes & block tuning
· Chapter 15 Quick System Review: Updated for 11gR2 and for much larger systems
· Chapter 16 Monitoring the System Using Unix Utilities: Unix chapter updated to include more commands
· Appendix A Key Initialization Parameters: Updated queries for 11gR2 & new Top 25 initialization parameters
· Appendix B V$ Views: Updated for 11gR2 with updated V$ view queries
· Appendix C X$ Tables: Updated for 11gR2 with updated X$ queries
Where to find this book
good
国内哪有卖这本书的?
Richard 长着两撇囧字眉
这本书哪里有卖了吗?
目前国内还没有发售, 请耐心等待, 相信不久会有中文版面世。
英文的pdf也搜不到
Where to find pdf of this book ?
为什么老想着要免费的PDF,请支持正版ORACLE书籍!
pdf 带着方便啊,绿色又环保,还适合中国国情!
你到网上看一下外文书籍多贵吧,你工资高不在乎,我们屌丝工程师当然不一样,一本英文书籍少的五六百,多的上千。能买得起几本
你说的也有道理, 但不能因为经济上有压力就不重视别人的知识产权吧?
正版哪里买呢?只能海淘吗
amazon.com
中文版可以由刘大来翻译。 英文版经常被翻译的,感觉老是说了半句话。