CSCI 397C - Spring 2001
Enterprise DBA: Part 2 Oracle 8i Performance Tuning
Reading Assignments and Related Course Notes and
Links to Powerpoint Slides
** Please note: This list is not complete for the entire semester. It only reflects the point we are at in the semester!
| Reading Assignment | Topic | Oracle Course Manuals and Notes on Web - take Link to Powerpoint Slides |
| Read by Jan. 22 | Course Introduction | Lesson 1 |
| Read by Jan. 22 | Tuning Overview | Lesson 2 |
| Read by Jan. 24 | Oracle Alert and Trace Files | Lesson 3 |
| Utilities and Dynamic Performance Views | Lesson 4 | |
| Tuning the Shared Pool | Lesson 5 | |
| Tuning the Buffer Cache | Lesson 6 | |
| Tuning the Redo Log Buffer | Lesson 7 | |
| Database Configuration and I/O Issues | Lesson 8 | |
| Using Oracle Blocks Efficiently | Lesson 9 | |
| Optimizing Sort Operations | Lesson 10 | |
| Tuning Rollback Segments | Lesson 11 | |
| Monitoring and Detecting Lock Contention | Lesson 12 | |
| SQL Issues and Tuning Considerations for Different Applications | Lesson 13 | |
| Managing a Mixed Workload | Lesson 14 | |
| Tuning with Oracle Expert | Lesson 15 | |
| Multithreaded Server Tuning Issues | Lesson 16 | |
| Tuning Workshop | Lesson 17 |
Back to Melody's Home Page -