Find reserved space figures for tables on a segment.
You can sort tables by their reserved sizes, which simplifies planning for a reorganization or rebuild.
- In the Perspective Resources view, select the server to monitor, click the drop-down arrow, and select Monitor.
- 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 monitor.
- (Optional for Adaptive Server cluster configurations) Select Global for information about segments on the global database. Select Local for information about segments on local, temporary databases.
- In the Segments table, select the segment to monitor.
- Click the Used Tables tab.
The tab displays the name and amount of space reserved, in kilobytes, for each table.
- 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 Adaptive Server System Administration Guide, Volume 2.