CSCI 397C - Spring 2000
Oracle 8 Performance Tuning
Reading Assignments and Related Course Notes
** 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 |
| Introduction | Intro | |
| Read by Jan. 26 | Tuning Overview | Lesson 1 |
| Read by Jan. 26 | Oracle Alert, Trace Files, and Events | Lesson 2 |
| Read by Jan. 31 | Utilities and Dynamic Performance Views | Lesson 3 |
| Read by Jan. 31 | Tuning Considerations for Different Applications | Lesson 4 |
| SQL Tuning | Lesson 5 | |
| Tuning the Operating System | Lesson 6 | |
| Tuning the Shared Pool | Lesson 7 | |
| Tuning the Buffer Cache | Lesson 8 | |
| Tuning the Redo Log Buffer | Lesson 9 | |
| Database Configuration and I/O Issues | Lesson 10 | |
| Using Oracle Blocks Efficiently | Lesson 11 | |
| Optimizing Sort Operations | Lesson 12 | |
| Tuning Rollback Segments | Lesson 13 | |
| Monitoring and Detecting Lock Contention | Lesson 14 | |
| Contention Issues | Lesson 15 | |
| Tuning with Oracle Expert | Lesson 16 | |
| Optimizing for Load | Lesson 17 | |
| Performance Tuning Workshop | Lesson 18 |
Back to Melody's Home Page -