Determining the Space Used by a Table on a Segment

Find reserved space figures for tables on a segment.

You can sort tables by reserved size, which simplifies planning for a reorganization or rebuild.

  1. In the Perspective Resources view, select the server to monitor, click the drop-down arrow, and select Monitor.
  2. In the left pane, select Segments.
    You can also display the Segments window by clicking a Segments link on another window in the Adaptive Server Enterprise monitor.
  3. (Optional for cluster configurations) Select Global for information about segments on the global database. Select Local for information about segments on local, temporary databases.
  4. In the Segments table, select the segment to monitor.
  5. Click the Used Tables tab.
    The tab displays the name and amount of space reserved, in kilobytes, for each table.
  6. To sort a table by reserved size, select the table and click Space Reserved.
For more information on segments, see the chapter on creating and using segments in the System Administration Guide, Volume 2.
Related tasks
Extending a Segment in SAP ASE
Displaying Information About Segments Used by a Database
Related reference
Segment Statistics and Details