I. Methods, concepts, and tools. Oracle performance tuning : a methodical approach ; Oracle architecture and concepts ; Tools of the trade
II. Application and database design. Logical and physical database design ; Indexing and clustering ; Application design and implementation
III. SQL and PL/SQL tuning. Optimizing the optimizer ; Execution plan management ; Tuning table access ; Joins and subqueries ; Sorting, grouping, and set operations ; Using and tuning PL/SQL ; Parallel SQL ; DML tuning
IV. Minimizing contention. Lock contention ; Latch and mutex contention ; Shared memory contention
V. Optimizing memory. Buffer cache tuning ; Optimizing PGA memory ; Other memory management topics
VI. IO tuning and clustering. Disk IO tuning fundamentals ; Advanced IO techniques ; Optimizing RAC.
