Tuning Memory Structures in Oracle9i

Overview/Description
To describe how to tune Oracle9i memory structures

Target Audience


Anyone wishing to learn about Oracle9i database performance tuning

Prerequisites


An understanding of database concepts and technologies

Expected Duration


200 Minutes

Objectives :

Tuning Memory Structures in Oracle9i

  • describe performance issues related to memory allocation in an Oracle9i database.
  • describe and analyze the components and performance of the shared pool in an Oracle9i database.
  • describe how to size and tune the shared pool and to assess how to improve shared pool performance in an Oracle9i database.
  • diagnose and tune shared pool performance in Oracle9i.
  • describe the buffer cache and discuss how to analyze it for Oracle9i database performance tuning.
  • describe how to size and tune the buffer cache and to assess methods of improving buffer cache performance in an Oracle9i database.
  • diagnose and tune buffer cache performance in Oracle9i.
  • analyze and tune the redo log buffer and size and tune the Java pool in an Oracle9i database.
  • describe the functions of latches and how to minimize latch contention in an Oracle9i database.
  • diagnose and minimize latch contention in an Oracle9i database.


    • Course Number: 70125_eng