Lesson 10 - Managing Rollback Segments

08/15/1999


Click here to start


Table of Contents

Managing Rollback Segments

Objectives

Rollback Segment

Rollback Segments: Purpose

Types of Rollback Segments

Transactions and Rollback Segments

Growth of Rollback Segments

Shrinkage of Rollback Segments

Read-Consistency

Planning Rollback Segments: Number

Planning Rollback Segments: Number of Extents

Creating Rollback Segments

Bringing Rollback Segments Online

How Instances Acquire Rollback Segments

Changing Rollback Segment Storage Settings

Deallocating Space from Rollback Segments

Taking Rollback Segment Offline

Dropping Rollback Segments

Rollback Segments in the Database

Rollback Segment Statistics

Rollback Segment: Current Activity

Rollback Segment Problems

Insufficient Space for Transactions

Read-Consistency Error

Blocking Session

Error in Taking a Tablespace Offline

Summary

Author: Oracle

Email: melody@ecst.csuchico.edu

Home Page: http://www.ecst.csuchico.edu/~melody

Download presentation source