U
UGA

See User Global Area (UGA).

Undo Advisor

A tool within the Oracle advisory framework that uses past undo usage to recommend settings for the UNDO_RETENTION parameter as well as an optimal size for the undo tablespace.

undo data

The data blocks changed or updated, along with pointers to rows inserted that are stored in an undo tablespace to support read consistency, rolling back, and recovery from failed transactions or an instance crash. Also referred to as rollback information.

undo segment

The segment that stores the before image of modified data; used for rollback or transaction recovery purposes.

undo tablespace

A special type of tablespace that holds undo data. Only one undo tablespace can be active in the database at any ...

Get OCA: Oracle 10g™ Administration I: Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.