Oracle Storage Manager (Revision #30)

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 displays :

• Detailed information of Tables and Indexes
• Table Storage now displays Table name, Tablespace, Type, Partitioned, Row Count, Index Size, Data Size, Segment Size and Created Date
• Index storage now includes Index Name, Index Type, Row Count, Index Size, Status, Unique, Created Date. You can quickly identify whether indexes are not created on Tables participating in SQL Queries
• Overall Object Storage information for Tablespaces. 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 -> Oracle 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
Table Schema: Owner of the Table
Object Type: Whether Sytem or User Index
Tablespace: Name of the tablespace containing the index
Buffer Pool:Name of the Bufferpool containing the index
Index Type: Type of the index
Index Size: Size of the Index
Valid: Whether the index is valid or not
Uniqueness: Whether the index is UNIQUE or NONUNIQUE
Rows: Number of rows in the index
Created Date: Date on which the index was created