Find reserved space figures for tables on a segment.
You can sort tables by reserved size, 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 Enterprise monitor.
- (Optional for 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 System Administration Guide, Volume
2.