Tuning Database Structures in Oracle9i

Overview/Description
To describe how to tune components of an Oracle9i database

Target Audience


Anyone wishing to learn about Oracle9i database performance tuning

Prerequisites


An understanding of database concepts and technologies

Expected Duration


180 Minutes

Objectives :

Tuning Database Structures in Oracle9i

  • describe I/O concepts and discuss how to analyze and tune I/O in an Oracle9i database.
  • diagnose and tune I/O performance problems in an Oracle9i database.
  • describe how to tune the sorting process and to differentiate between types of sorts in an Oracle9i database.
  • discuss undo management and how to monitor and tune rollback segment activity in an Oracle9i database.
  • manually determine the number and size of rollback segments in an Oracle9i database.
  • describe the types and features of locks and to describe how to avoid lock contention in an Oracle9i database.
  • explain how to optimize extent management and to discuss the high-water mark.
  • discuss how to optimize block and index usage in an Oracle9i database.
  • detect and resolve row migration and chaining in an Oracle9i database.


    • Course Number: 70130_eng