2群基础群 适合刚入门的同学，会共享最佳入门实践和资料 QQ群 # QQ群号:171092051 # 已经升级到 500人的超级群，空位多多，无需面试
Richard Niemiec又一力作《Oracle Database 11g Release 2 Performance Tuning Tips & Techniques》
对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
随着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
posted on 2013-03-19 00:51 Oracle和MySQL 阅读(372) 评论(0) 编辑 收藏 举报
