<< Click to Display Table of Contents >>

Sort Segment Usage

Top Previous Next

The page shows the sort segments and their usage for a temporary tablespace. The grid remains empty for permanent tablespaces. The following information is available:

Segment file

Segment block

Extent size

Current users

Total extents

Total blocks

Used extents

Used blocks

Free extents

Free blocks

Added extents

Extent hits

Freed extents

Free requests

Max size

Max blocks

Max used size

Max used blocks

Max sort size

Max sort blocks

Clicking on the plus sign to the left of the segment causes additional information to be displayed:


Session address

Session number

SQL address

SQL hash


Segment file number

Segment block number