Course in Oracle 9i Database Performance Tuning (Paper 5)

Database performance tuning is critical to any effective information system. Reducing wait times, increasing users' productivity and maximising the performance of an Oracle database are critical to its success. This paper introduces the importance of good initial database design, and the method to tune a production Oracle 9i database. By the end of this segment, students will gain practical experience in tuning an Oracle database.

After the completion of this course, the student will be able to:

* Describe the roles associated with the database tuning process
* List the important steps in tuning methodology
* Describe how the buffer cache is used by different Oracle processes
* Define levels of locking
* Describe how to perform tuning tasks with Oracle Enterprise Manager and command line interface
* Optimise sort operations
* Describe configuring resource manager to control resource usag