Oracle Performance Tuning for 10gR2, 2/e

Description

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