Scalability and Performance in Oracle9i

Overview/Description
To describe the scalability and performance enhancements available in an Oracle9i database

Target Audience
Database operators, administrators, and developers interested in the new technical features and benefits of an Oracle9i database

Prerequisites
Experience in Oracle database administration; familiarity with RDBMS technologies

Expected Duration
265 Minutes

Objectives:

Scalability and Performance in Oracle9i

  • monitor index usage and explain skip scanning and Bitmap Joined Indexes in an Oracle9i database.
  • enable, disable, and monitor index usage in an Oracle9i database.
  • use the new optimizer cost model in an Oracle9i database.
  • explain and use the new outline editing features in an Oracle9i database.
  • explain and implement cursor sharing and cached execution plans in an Oracle9i database.
  • provide an overview of a Real Application Cluster and its architecture in an Oracle9i database.
  • explain cache fusion in Oracle9i database Real Application Clusters.
  • provide an overview of the new features of Oracle9i database Real Application Clusters.
  • explain list partitioning and how to implement it in an Oracle9i database.
  • implement list partitioning in an Oracle9i database.
  • use the new segment management features in an Oracle9i database.
  • use external tables in an Oracle9i database.
  • describe the enhancements of the Oracle9i database Resource Manager and implement the Resource Manager.
  • describe and use the new session state management features of an Oracle9i database.


    • Course Number: 58176_eng