Sybase ASE Storage Manager (Revision #4)

With Aqua Data Studio 7.5 you can plan, initialize, allocate, manage, and tune Oracle database objects for better performance

New enhanced Object Tab in Aqua Data Studio 7.5 gives:

• Detailed information of Tablespaces
• High-level storage information of Tables which helps in tracking growth
• Index storage that now includes Index Type, Size, Rows, Validity and Created Date. You can quickly identify whether indexes are not created on Tables participating in SQL Queries
• Overall Object Storage information. You can sort and quickly identify which Table or Index takes up more space. You can configure Storage and eliminate wasted storage

Object Tab - Display of the Tables and Indexes.

Documentation -> Sybase ASE DBA Tools -> Storage Manager

Below text goes to ADS 7.5 Documentation.

Object Name: Name of the database object
Owner: Owner of the table
Object Type: Type of the database object
Tablespace: Name of the tablespace containing the table
Bufferpool: Name of the Bufferpool containing the table
Partitioned: Specify whether the table is partitoned or not
Table Size: Total Size occupied by the table. Calculated by NUM_ROWS * AVG_ROW_LEN
Segment Size: Total size of the extent occupied by the table. Calculated by SUM(BYTES)
Row Count: Total number of rows in the table
Index Size: Space used by Indexes in the table
Created Date: Date on which the table was created

Type = Index

Index Name: Name of the index object
Index Schema: Owner of the Index
Table Name: Name of the database object
Segment: Owner of the Table
Object Type: Whether Sytem or User Index
Row Count: Name of the tablespace containing the index
Reserved:Name of the Bufferpool containing the index
Data: Type of the index
Indexes: Size of the Index
Unused: Whether the index is valid or not
Created Date: Date on which the index was created
Lock Type: Date on which the index was created