<< Click to Display Table of Contents >>

Rollback Segments

Top Previous Next

The upper grid displays the following information about rollback segments in the database:

Rollback segment

Owner

Tablespace

Size

Status

Extents

Max extents

High-water mark of segment size

Writes

Transactions

Gets

Waits

Optimal

Shrinks

Wraps

Extends

Avg Shrink

Avg Active

Initial extent

Next extent

Percent increase

Instance Number

The following context operations are available:

RbsCreate

Create

Creates a new rollback segment.

Shrink

Shrink

Shrinks rollback segment size.

05_Properties

Properties/Alter

Shows a modal dialog for viewing and modifying rollback segment properties.

07_Drop

Drop

Drops the rollback segments.

Enable

Online

Switches rollback segment status.

DISABLE

Offline

 

Grid View

For more information, see object window

 

The second grid shows open transactions that are using the current rollback segment and information about the session that started the transaction:

Start SCNB

Start SCNW

Start time

Recursive

Space

Aud SID

SID

Status

Username

Terminal

Program client