CSCI 397C - Spring 2001
Enterprise DBA: Part 2 Oracle 8i Performance Tuning
Reading Assignments and Related Course Notes and
| Reading Assignment | Topic | Oracle Course Manuals |
| week 1 | Course Introduction | Lesson 1 |
| week 1 | Tuning Overview | Lesson 2 |
| week 1 | Oracle Alert and Trace Files | Lesson 3 |
| week 2 | Utilities and Dynamic Performance Views | Lesson 4 |
| week 3 | Tuning the Shared Pool | Lesson 5 |
| week 3 | Tuning the Buffer Cache | Lesson 6 |
| week 4 | Tuning the Redo Log Buffer | Lesson 7 |
| week 4 | Database Configuration and I/O Issues | Lesson 8 |
| week 5 | Using Oracle Blocks Efficiently | Lesson 9 |
| week 5 | Optimizing Sort Operations | Lesson 10 |
| week 6 | Tuning Rollback Segments | Lesson 11 |
| week 7 | Monitoring and Detecting Lock Contention | Lesson 12 |
| week 8 | SQL Issues and Tuning Considerations for Different Applications | Lesson 13 |
| week 9 | Managing a Mixed Workload | Lesson 14 |
| week 10 | Tuning with Oracle Expert | Lesson 15 |
| week 11 | Multithreaded Server Tuning Issues | Lesson 16 |
| week 12-15 | Tuning Workshop | Lesson 17 |
Back to Melody's Home Page -