Scalability and Performance in Oracle9i

This course is included in our On-demand training solution.

Overview

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 min.

Course 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?