Data Storage in Oracle9i

Overview/Description
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 Minutes

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.


    • Course Number: 59293_eng