Performance, Tuning et Optimisation du SGBD Oracle 8i et 9i

A la demande de Paula, mon article sur les perfs Oracle: 

Je viens de trouver un livre sur les pratiques de bonnes utilisations d’un SGBD Oracle (Perspective de joie et bonheur pendant plusieurs centaines d’heures) 

Google diffuse une version amputé du livre ici :

http://books.google.ca/books?id=VujhRRg65yQC&pg=PP1&dq=Database+Performance+Tuning+and+Optimization&ei=B0sSSePrDIPMM83zufYC&hl=fr#PPP1,M1

 Ce livre, plutôt très complet, offre des guides “appliqués” concernant les thèmes suivant: 

Part 1 Methodology

 1 Database Application Development (Enterprise Modeling, Physical, Normal Forms, Logical and Physical Database Design, Naming Guidelines for Database Objects,…)
2 Performance Tuning Methodology (the Three Levels, Optimization at Each Level, Process and Metric for Performance Tuning,…)
3 Tuning the Conceptual Level of a Database (Performance Issues at the Conceptual Level, Denormalization of the Conceptual Level, Optimal Indexing of Tables, Integration of Views into Queries, Partitioning of Tables and Indices,…) 

Part 2 Oracle Tools for Tuning and Optimization

4 Internal Level of an Oracle Database (Oracle Instance, Internal Level Tuning Methodology, V$ Views and X$ Tables, Initialization Parameters for an Oracle Database,…)
5 Tuning of Disk Resident Data Structures (Performance Tuning of Disk-Resident Data Structures, Used and Free Space Fragmentation at the Segment Level, Performance Tuning of Rollback Segments,…)
6 Tuning of Memory-Resident Data Structures (Performance Tuning, Shared SQL Pool, Background Processes, Tuning the Memory,…)
7 Oracle Utility for Tuning and Optimization (Location, Function, Procedure of usage and Performance Report Analysis of UTLBSTAT and UTLESTAT Utilities, Performance Tracking, …)
8 Optimization of the External Level of a Database (Principles of Query Optimization, Query Optimization in Oracle, Optimal Indexing Guidelines, Tools for Tracking Query Performance, …)
9 Query Tuning and Optimization Under Oracle 8i
10 Special Features of Oracle 8i and a Glimpse into Oracle 9i

Part 3 Contemporary Issues

11 Tuning the Data Warehouse at All Levels
12 Web-Based Database Applications 

Appendices
Appendix A Sizing Methodology in Oracle 8i
Appendix B Instance and Database Creation
Appendix C Instance and Database Removal
Appendix D Database Refresh with Transportable Tablespaces
Appendix E Mathematical Foundation of Relational Databases