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

【书籍推荐】Oracle 8i Internal Services

直到今天仍是经典,无可替代,绝不落伍。想了解Oracle internal 必读的一本书,每次翻开影印本都会有所收获,感谢作者的无私贡献!
[gview file=”http://askmaclean.com/wp-content/uploads/resource/oracle8i.internal.services.for.waits.latches.locks.pdf”]

【书籍推荐】Expert Oracle Practices

类似于《Oracle dba日记》,由国外一群Oracle专家合著,够fashion!

Expert_Oracle_Practices

PostgreSQL.Essential.Reference

download PostgreSQL Essential Reference here

Book:Building a WordPress

Building a wordpress blog download

AIX学习经典书籍:AIX 5L Administration

McGraw-Hill出版的经典AIX学习书籍,作者是Randal K.michael, 仅作学习研究用途。

AIX5L_administration

沪ICP备14014813号

沪公网安备 31010802001379号