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

Aptech Computer Education
In Mumbai

Price on request
Compare this course with other similar courses
See all

Important information

  • Course
  • Mumbai
  • 40 hours of class

Important information

Where and when

Starts Location
On request
A-302, Vertex Vikas Building Above A to Z Jumbo Zerox Opp. Andheri Railway Station M.V.Road Andheri (East) , 400069, Maharashtra, India
See map

Frequent Asked Questions

· Requirements

Eligibility:- Prior knowledge of Oracle 9i Database Administration Fundamentals I and Oracle 9i Database Administration Fundamentals II courses is essential.

Course programme

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

Compare this course with other similar courses
See all