Oracle Database 10g: New Space Management Features


Overview/Description
To identify the new space management features of Oracle 10g

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration
140 Minutes

Objectives:

Oracle Database 10g: New Space Management Features

  • identify the new features of undo management and their functions in Oracle Database 10g.
  • set tablespace space usage thresholds in Oracle Database 10g.
  • set a space usage threshold for a tablespace in a given scenario in Oracle Database 10g.
  • use the appropriate code to define sorted hash clusters in Oracle Database 10g.
  • perform a segment shrink operation in Oracle Database 10g.
  • access the tools used to optimize segment space in Oracle Database 10g.
  • perform a segment shrink operation in a given scenario in Oracle Database 10g.

  • Course Number: 210086_eng