Oracle Performance Tuning for 10gR2, 2/e

Gavin JT Powell

  • 出版商: Digital press
  • 出版日期: 2006-09-01
  • 定價: $2,600
  • 售價: 1.9$499
  • 語言: 英文
  • 頁數: 960
  • 裝訂: Paperback
  • ISBN: 1555583458
  • ISBN-13: 9781555583453
  • 相關分類: Oracle
  • 立即出貨 (庫存=1)




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.


Table of Contents

Introduction Part 1: Security Standards and Compliance Part 2: HP NonStop server Subsystems Chapter 1: Safeguard Subsystem Updates Chapter 2: TCP/IP Subsystem Chapter 3: TSM/OSM Subsystem Chapter 4: DSM/SCM Subsystem Chapter 5: The Open System Services (OSS) Chapter 6: ODBC Chapter 7: SQL/MX Part 3: The Guardian Gazette A – Z Part 4: The OSS Gazette Appendices Appendix A: Gathering The Audit Information Appendix B: Tandem File Codes Appendix C: Third Party HP NonStop Server Security