Aptech Computer Education - Oracle 9i Database Performance Tuning (Paper 5)

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

Who will the course benefit?

Students and working professionals who wish to gain expertise in Oracle database and instance tuning

What skills will the student gain?


Prerequisites
Prior knowledge of Oracle 9i Database Administration Fundamentals I and Oracle 9i Database Administration Fundamentals II courses is essential

Duration
40 hours

Certification
Certificate of participation (Additionally, students can appear for Oracle 9i Performance Tuning vendor certification)

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 usage

> Back