An Oracle scheduler object that specifies a start date, optional end date, and repeat interval that can be used to generate dates and times for job execution.

Segment Advisor

A tool available either via a PL/SQL package or within EM Database Control that analyzes a segment or all segments within a tablespace and recommends remedial action to optimize the space within the segments.

Segment Resource Estimation

A tool available only within EM Database Control that can estimate space usage for a new table segment given the column datatypes, sizes, and the estimated row count.

segment shrink

The functionality using either ALTER TABLE or the EM Database Control interface to reclaim wasted space within a segment and optionally move ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.