Oracle Database 10g: New Space Management Features

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

Target Audience
Oracle 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 (hours)
2.3

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