Tuning Systems and Applications in Oracle9i

Overview/Description
To describe how to tune systems and applications in Oracle9i

Target Audience


Anyone wishing to learn about Oracle9i database performance tuning

Prerequisites


An understanding of database concepts and technologies

Expected Duration


160 Minutes

Objectives :

Tuning Systems and Applications in Oracle9i

  • describe the Oracle9i Cost-Based Optimizer and its role in SQL statement processing.
  • discuss the methods for tuning SQL in an Oracle9i database.
  • use the SQL trace and TKPROF facilities.
  • provide an overview of the DBA's role in Oracle9i application tuning.
  • describe how to tune storage structures in an Oracle9i database.
  • describe how to tune indexes and materialized views in an Oracle9i database.
  • describe how to configure Oracle9i database shared servers.
  • describe operating system tuning considerations for Oracle9i databases.


    • Course Number: 70135_eng