Oracle Performance Survival Guide available as PDF
My new book Oracle Performance Survival Guide just became available for PDF download at Informit.com!
The print version is available for pre-order at Informit or Amazon and elsewhere, and is due in book stores on October 14th. There will be copies available at the Oracle Open World book store next week however and we'll be having a book signing with giveaways at the Quest Software booth, probably on Wednesday. I haven't seen a print copy myself yet, but I was probably the first to buy a digital copy :-). It will also soon be available on Kindle and on the Safari on-line bookshelf.
This is the most challenging book I've written, and the most extensive in terms of scope. I tried to write a book that would be accessible across a broad range of expertise, and which would systematically address most major aspects of Oracle RDBMS performance tuning. Overall, I'm satisfied that it's a worthwhile contribution to Oracle performance literature.
You can see the full table of contents at the books Informit webpage, but here's the short chapter list to give you an idea:
PART I: METHODS, CONCEPTS, AND TOOLS
1 Oracle Performance Tuning: A Methodical Approach
2 Oracle Architecture and Concepts
3 Tools of the Trade
PART II: APPLICATION AND DATABASE DESIGN
4 Logical and Physical Database Design
5 Indexing and Clustering
6 Application Design and Implementation
PART III: SQL AND PL/SQL TUNING
7 Optimizing the Optimizer
8 Execution Plan Management
9 Tuning Table Access
10 Joins and Subqueries
11 Sorting, Grouping, and Set Operations
12 Using and Tuning PL/SQL
13 Parallel SQL
14 DML Tuning
PART IV: MINIMIZING CONTENTION
15 Lock Contention
16 Latch and Mutex Contention
17 Shared Memory Contention
PART V: OPTIMIZING MEMORY
18 Buffer Cache Tuning
19 Optimizing PGA Memory
20 Other Memory Management Topics
PART VI: IO TUNING AND CLUSTERING
21 Disk IO Tuning Fundamentals
22 Advanced IO Techniques
23 Optimizing RAC
Scripts, examples and packages are available for download here.