Data Storage in Oracle9i

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

Overview

To describe the data storage structures in an Oracle9i database and explain how to manage them

Target Audience

Anyone wanting to learn about Oracle9i database administration

Prerequisites

An understanding of database concepts and technologies

Expected Duration

195 min.

Course Objectives

Data Storage in Oracle9i

  • describe the database storage hierarchy and the types of tablespaces in the Oracle9i Database, and explain how to use them.
  • describe how to manage tables in an Oracle9i database.
  • explain how to manage tablespaces in an Oracle9i database.
  • explain how to manage data files in an Oracle9i database.
  • describe segments, extents, and datablocks in an Oracle9i database and explain how to manage them.
  • create a tablespace and move a data file using the Oracle Enterprise Manager in an Oracle9i database.
  • describe the purpose and types of undo segments in an Oracle9i database and explain how to use automatic undo management to administer undo data.
  • obtain information about undo segments, establish user quotas, and determine the required size of an undo tablespace in an Oracle9i database.
  • create and administer an undo tablespace in an Oracle9i database using the Oracle Enterprise Manager.
  • determine the optimal size for an undo tablespace in an Oracle9i database.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?