This was not as difficult as I expected. I used Sybex, Couchman, the ILT slides from the link posted on this forum, and I copied and ran a lot of scripts from Oracle Performance Tuning by Richard J. Niemiec.

I do not have any specific questions written down from the exam.


1. Tuning Overview (1)
2. Oracle Alert and trace files (2)
3. Utilities & Dynamic erformance Views (3)
4. Tuning the Shared Pool (7)
5. Tuning the Buffer Cache (7)
6. Tuning the Redo Log Buffer (3)
7. Database Configuratin and I/O issues (7)
8. Using Oracle Block Efficiency (4)
9. Optimizing Sort Operations (4)
10. Tuning Rollback segments (4)
11. Monitoring and Detecting Lock Contention (5)
12. SQL Issues and Tuning Considerations for (5)
Different applications
13. Managing a Mixed Workload (2)
14. Tuning with Oracle Expert (1)
15. Multithreaded server Tuning Issues (2)