Rollback Segment Tuning

Objectives

Rollback Segments: Usage

Rollback Segment Activity

Rollback Segment Header Activity

Growth of Rollback Segments

Transaction Types

Tuning the Rollback Segments

Diagnostic Tools for Tuning Rollback Segments

Diagnosing Rollback Segment Header Contention

Diagnosing Rollback Segment Contention

Guidelines: How Many Rollback Segments?

Guidelines: Sizing Rollback Segments

Sizing Transaction Rollback Data

Sizing Transaction Rollback Data

Using Less Rollback

Using Less Rollback

Possible Problems

Summary