<< Click to Display Table of Contents >>

Segments/Extents

Top Previous Next

The Overview Owners tab shows a pie diagram view of tablespace utilization by user:

tablespace_segments_Pie

In the Segments tab the grid shows the owners of extents (i.e. objects) stored in the current tablespace:

Owner of the segments

Segments type (Table, Index, ...)

Number of Segments

Usage in KBytes

Clicking on the plus sign to the left of a particular segment type shows information about each of the segments.

Segment Name

Type of segment ( TABLE, CLUSTER, INDEX, ROLLBACK,DEFERRED, etc.)

Size of the segment in KBytes

Next-segment size, in Kbytes

Increase (%)

Number of extents allocated to the segment

Allocable (extents)

The context toolbar and the right mouse button popup menu allow the following operations:

Tablespace

Move tablespace

Shows a modal dialog for moving a segment to another tablespace

05_Properties

Properties/Alter/Rebuild

Shows a modal dialog for viewing and modifying properties of the selected object. The type of object determines which dialog will be displayed.

 

Grid View

For more information, see object window